Function to set Date
 

Hi,

I would like to know how to set below equation:-

to set the 1-week (i.e Monday) prior to a specific date: e.g. 2009/11/24, i
would like to have the output = 2009/11/16

e.g. 2009/12/31, output = 2009/12/21
--
J

Function to set Date
 

Hi,

Try this. Cell B16 holds the specific date

=B16-7-CHOOSE(WEEKDAY(B16-7,2),0,1,2,3,4,5,6)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"J" wrote in message
...
Hi,

I would like to know how to set below equation:-

to set the 1-week (i.e Monday) prior to a specific date: e.g. 2009/11/24,
i
would like to have the output = 2009/11/16

e.g. 2009/12/31, output = 2009/12/21
--
J