CODEWITHSUNDEEP
exceldateexcel-formula
B. Maritz
B. Maritz

Reputation: 25

Excel date calculation within a specific week number

I need to figure out how to get the dates for both the Tuesday and Thursday in the next week.

I'm currently getting the week number by using: =WEEKNUM(NOW(),)+1 I'm not sure where to go from here, please help me out.

Upvotes: 0

Views: 43

Answers (1)

Jerry
Jerry

Reputation: 71598

You could use the following for Tuesday:

=NOW()+9-WEEKDAY(NOW(),2)

9 because 1 week is 7 days, then Tuesday is day 2 of the week, so 7+2=9.

For Thursday:

=NOW()+11-WEEKDAY(NOW(),2)

Same reasoning as above with Thursday being 4, so 7+4=11.

The formula basically takes the current date, adds a week (7) and then adjusts for the weekday considering today's weekday.

Upvotes: 1

Related Questions