software

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.

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-Proquot;Scottquot; wrote:

gt; Is there a function in Excel to change a date to the first of the month,
gt;
gt; ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005
gt;
gt; thanks.

quot;Scottquot; gt; wrote in message
...
gt; Is there a function in Excel to change a date to the first of the month,
gt;
gt; ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005
gt;
gt; thanks.

=DATE(YEAR(NOW()),MONTH(NOW()),1)
Another alternative to EOMONTH: =today()-day(today()) 1
(or, to operate on a date given in A1, =a1-day(a1) 1. )quot;Scottquot; wrote:

gt; Is there a function in Excel to change a date to the first of the month,
gt;
gt; ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005
gt;
gt; thanks.

On Thu, 22 Dec 2005 05:43:03 -0800, quot;Scottquot; gt;
wrote:

gt;Is there a function in Excel to change a date to the first of the month,
gt;
gt;ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005
gt;
gt;thanks.

=TODAY()-DAY(TODAY()) 1--ron