Need a hand with date calc
On Mar 2, 2:04*am, kirkm wrote:
On Sun, 1 Mar 2009 21:50:19 -0800 (PST), CurlyDave
wrote:
try this
=DATE(YEAR(E1),MONTH(E1),DAY(E1)+CHOOSE(WEEKDAY(E 1),
1,0,-1,-2,-3,3,2,1))
Can you give me a parameter for E1 ?
What are all those numbers ?
E1 is a date, the formula displays the closest Monday to that date as
that is what
Dec 30 1939 is.
|