Thread: Monday closest to today's date?
View Single Post
  #2  
Old March 16th, 2010, 02:02 PM posted to microsoft.public.excel.worksheet.functions
zxcv[_2_]
external usenet poster
  
Posts: 9
Default Monday closest to today's date?
On Mar 16, 9:50*am, "Ted" wrote:
Hello:

I am seeking a formula that would return the date of the closest Monday to
today's date. *The monday would have to be the first one in the future, not
the past. *So today, Tuesday March 16, 2010, the formula would return
Monday, March 22, 2010

Thanks in advance

How about this?

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+7-WEEKDAY(TODAY(),3))