Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
setting the date to monday
is there a way the i could create a formula that would check the
current date and then set the date to monday of the week. examples: on date 07.Nov 07. The formula would give me 05.nov 07 (monday) on date 23. Nov 07. The formula would give me 19.nov 07(monday) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
adding day (sunday, Monday) to date | Excel Worksheet Functions | |||
Date to a day (Monday, Tue, etc?) | Excel Discussion (Misc queries) |