| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Given today's date, I want this week's Monday's date
Hello
I cannot find a good way to extract this week's monday's date. I want the sheet to read Today() and return the date of the monday of this week. I would prefer to NOT do this in VBA but that is an option. I consider myself a pretty advanced Excel/VBA user so please unload. I am using Excel 2003 with NO ability to switch versions. Also, I am generally regarding Monday to start a week, such that the week is MTWThFSaSu. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Display Monday's date only on x-axis | Charts and Charting in Excel | |||
| I need today's date returned as date format in formula | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
Threaded Mode
