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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Given today's date, I want this week's Monday's date
With today in A1 try
=A1+CHOOSE(WEEKDAY(A1),1,0,-1,-2,-3,-4,-5) Mike "BlueWolvering" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Given today's date, I want this week's Monday's date
On Tue, 12 Feb 2008 08:00:03 -0800, BlueWolvering
wrote: 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! If I understand you correctly, this should do what you want: =A1+1-WEEKDAY(A1+6) will return the preceding Monday, unless A1 is a Monday, in which case it will return the same date. Substitute TODAY() for A1 to work on today's date. --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Given today's date, I want this week's Monday's date
Another one:
=TODAY()-WEEKDAY(TODAY(),3) Or: A1 =TODAY() =A1-WEEKDAY(A1,3) -- Biff Microsoft Excel MVP "BlueWolvering" wrote in message ... 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! |
Reply |
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 |