Project a day of the week

C

Connie G

I have a workbook created and on each worksheet I have a
date in which a project is to be completed and I need to
project the next meeting date based upon completion date.
For example, one sheet contains projects with different
dates in December, however, this unit meets every Tuesday.
So on this sheet the formula should project the next
upcoming Tuesday based on each different completion date.
 
M

Mark Graesser

The following formula assumes the completion date is in cell B5

=B5+(3-WEEKDAY(B5))+IF(WEEKDAY(B5)>3,7,0

This formula finds the closest Tuesday to the completion date, and if it is before the completion date, the IF statement adds one week

Good Luck
Mark Graesse
[email protected]


----- Connie G wrote: ----

I have a workbook created and on each worksheet I have a
date in which a project is to be completed and I need to
project the next meeting date based upon completion date.
For example, one sheet contains projects with different
dates in December, however, this unit meets every Tuesday.
So on this sheet the formula should project the next
upcoming Tuesday based on each different completion date
 
D

Daniel.M

Hi Connie,
So on this sheet the formula should project the next
upcoming Tuesday based on each different completion date.
Click to expand...

For any date in A1:
=A1-WEEKDAY(A1-2)+8 ' gives the Next Tuesday
=A1-WEEKDAY(A1-3)+7 ' gives the Current/Next Tuesday In this case, if A1 is a
Tuesday, it returns the same date.

Regards,

Daniel M.
 
Top