Project a day of the week

[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.

 

[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
(e-mail address removed)


----- 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

 

[Daniel.M]

Hi Connie,

So on this sheet the formula should project the next
upcoming Tuesday based on each different completion date.

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.