Date function

[Anauna]

How can I set a function to show the date for the Monday of the current week?

 

[Anauna]

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

Thanks

 

[JulieD]

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