Project a day of the week

  • Thread starter Thread starter Connie G
  • Start date Start date
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.
 
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
 
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.
 
Back
Top