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.