Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing today's date to the first of the month
Is there a function in Excel to change a date to the first of the month,
ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005 thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing today's date to the first of the month
Try one of these:
=EOMONTH(TODAY(),-1)+1 Note: If the EOMONTH function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in OR =DATE(YEAR(TODAY()),MONTH(TODAY()),1) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Scott" wrote: Is there a function in Excel to change a date to the first of the month, ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005 thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing today's date to the first of the month
"Scott" wrote in message
... Is there a function in Excel to change a date to the first of the month, ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005 thanks. =DATE(YEAR(NOW()),MONTH(NOW()),1) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing today's date to the first of the month
Another alternative to EOMONTH: =today()-day(today())+1
(or, to operate on a date given in A1, =a1-day(a1)+1. ) "Scott" wrote: Is there a function in Excel to change a date to the first of the month, ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005 thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing today's date to the first of the month
On Thu, 22 Dec 2005 05:43:03 -0800, "Scott"
wrote: Is there a function in Excel to change a date to the first of the month, ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005 thanks. =TODAY()-DAY(TODAY()) +1 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
extract the month of a date | Excel Discussion (Misc queries) | |||
How do I break a date range by month? | Excel Discussion (Misc queries) | |||
Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
Today's Date | Excel Discussion (Misc queries) |