Date function
 

How can I set a function to show the date for the Monday of the current week?
--
Thank-you and all suggestions are appreciated.

Sorry for the inconvience found my solution at
http://www.mvps.org/dmcritchie/excel/datetime.htm

Thanks

"Anauna" wrote:

How can I set a function to show the date for the Monday of the current week?
--
Thank-you and all suggestions are appreciated.

Hi

to return the date of the monday prior to any date you can use the following
formula
=A1-(WEEKDAY(A1,2)-1)
(where A1 holds the date you're interested in)

therefore to return the date of the monday of the current week just
substitute today() for A1
=Today()-(Weekday(today(),2)-1)

Cheers
JulieD


"Anauna" wrote in message
...
How can I set a function to show the date for the Monday of the current
week?
--
Thank-you and all suggestions are appreciated.