Monday closest to today's date?

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 12

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 :)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date in Cell to change colors if the date is beyond today's date	Pete Elbert	Excel Discussion (Misc queries)	2	June 6th 09 06:31 AM
Array Lookup to Find Closest Date and Next Closest Date	[email protected]	Excel Worksheet Functions	7	November 7th 07 03:04 AM
Date calculation for Monday of one month to the Monday of the next	Sunnyskies	Excel Discussion (Misc queries)	19	July 2nd 07 12:08 PM
finding a date/time in a list that is closest to an existing date/	Jamie	Excel Discussion (Misc queries)	1	May 27th 06 08:54 PM
Finding the Monday date based on a different date in same week	dandiehl	Excel Worksheet Functions	4	April 11th 06 06:03 PM

All times are GMT +1. The time now is 09:50 PM.

Menu

About Us