Thread: Monday closest to today's date?
View Single Post
  #1  
Old March 16th, 2010, 01:50 PM posted to microsoft.public.excel.worksheet.functions
Ted[_15_]
external usenet poster
  
Posts: 10
Default Monday closest to today's date?
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