date should always be Monday
 

Hello I'm creating a form/report for engineers to complete
I need a formula to give me the day of Monday of the current week.
Example if the report is completed Tuesday March 17, the cell should read
March 16, 2009 thanks

date should always be Monday
 

=A2-WEEKDAY(A2,2)+1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Wanna Learn" wrote in message
...
Hello I'm creating a form/report for engineers to complete
I need a formula to give me the day of Monday of the current week.
Example if the report is completed Tuesday March 17, the cell should read
March 16, 2009 thanks