Date Formula

[Mike]

Is it possible to return a date for a particular day in
the week that you are in? ie.

As today is 15/07/2003 I want to return wednesdays date
for that week which is the 16/07/2003, and if I was in
the next week, I would want to return the wednesday date
for that week


Thanks in Advance

 

[Andy]

Mike

Try this:
=TODAY()-WEEKDAY(TODAY())+4

Andy.

 

[Mike]

NOW() returns the current date/time. WEEKDAY() returns a
number 1 to 7 for Sunday to Saturday depending on the date
used. So Wednesday is 4. Combine them into this formula
to return Wednesday no matter what day it is.

=NOW()-WEEKDAY(NOW())+4