| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting the date to monday | Excel Worksheet Functions | |||
| Date calculation for Monday of one month to the Monday of the next | Excel Discussion (Misc queries) | |||
| HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007) | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| Date to a day (Monday, Tue, etc?) | Excel Discussion (Misc queries) | |||
Linear Mode
