Its another Monday Thing

Stevealexa · May 25th, 2002, 01:07 PM

I have a cell c12 that contains a date.
It can be any date.
C11 contains another date usually NOW()
C12 will be before NOW().
I need to caluclate the date from c12 to the next MONDAY and then the dates of all mondays until NOW()
Writing them to the C column.
ANY IDEAS Ladies and Gentleman.Its way beyond me !!!

Steve

Dave Patton · May 25th, 2002, 01:56 PM

Hello Steve
consider the following

C11 25/05/2002 =today()
C12 12/05/2002
C13 Mon 13/05/2002
C14 Mon 20/05/2002

C13
=IF(C12-WEEKDAY(C12,3)
C14
=IF(C13+7

Aladin Akyurek · May 25th, 2002, 01:57 PM

In C13 enter:

=IF(C12+7 >= C11,"",C12+(E1 < WEEKDAY(C12))*(7-WEEKDAY(C12)+E1)+(E1 >= WEEKDAY(C12))*(E1-WEEKDAY(C12)))

In C14 enter and copy down:

=IF(C13+7 >= $C$11,"",C13+7)

where E1 houses th day numbering for Monday which is 2 (Sunday=1,Monday=2, etc.)

[ This Message was edited by: aladin akyurek on 2002-05-25 13:40 ]

Stevealexa · May 25th, 2002, 02:31 PM

Thank you Gentleman

YOU ARE BOTH STARS

Kind regrds
Steve

[ This Message was edited by: Stevealexa on 2002-05-25 13:32 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 01:07 PM	#1
Stevealexa New Member Join Date: May 2002 Posts: 11	I have a cell c12 that contains a date. It can be any date. C11 contains another date usually NOW() C12 will be before NOW(). I need to caluclate the date from c12 to the next MONDAY and then the dates of all mondays until NOW() Writing them to the C column. ANY IDEAS Ladies and Gentleman.Its way beyond me !!! Steve

May 25th, 2002, 01:56 PM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	Hello Steve consider the following C11 25/05/2002 =today() C12 12/05/2002 C13 Mon 13/05/2002 C14 Mon 20/05/2002 C13 =IF(C12-WEEKDAY(C12,3) C14 =IF(C13+7

May 25th, 2002, 01:57 PM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	In C13 enter: =IF(C12+7 >= C11,"",C12+(E1 < WEEKDAY(C12))(7-WEEKDAY(C12)+E1)+(E1 >= WEEKDAY(C12))(E1-WEEKDAY(C12))) In C14 enter and copy down: =IF(C13+7 >= $C$11,"",C13+7) where E1 houses th day numbering for Monday which is 2 (Sunday=1,Monday=2, etc.) [ This Message was edited by: aladin akyurek on 2002-05-25 13:40 ]

May 25th, 2002, 02:31 PM	#4
Stevealexa New Member Join Date: May 2002 Posts: 11	Thank you Gentleman YOU ARE BOTH STARS Kind regrds Steve [ This Message was edited by: Stevealexa on 2002-05-25 13:32 ]