I need a formula to make a date land only on Wednesday. I already have a formula in the cell of =WORKDAY(AO64,7) so what is a formula to make that date land on a Wednesday? Thank you!
I need a formula to make a date land only on Wednesday. I already have a formula in the cell of =WORKDAY(AO64,7) so what is a formula to make that date land on a Wednesday? Thank you!
If it should always be the next Wednesday [i.e. a date on or after that returned by =WORKDAY(AO64,7)] try
=WORKDAY(AO64,7)-WEEKDAY(WORKDAY(AO64,7)+3)+7
Last edited by daddylonglegs; 06-11-2008 at 07:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks