DATE = 1ST OF MTH
 

I need a date formula that will insert the date as the
1st of what ever month it is, i.e. in Feb, no matter what
the date is ,it would return 2/1/2004. In Mar it would
always be 3/1/2004.

Any help is appreciated.

DATE = 1ST OF MTH
 

Use the following formula:

=DATE(YEAR(NOW()),MONTH(NOW()),1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"RONBO" wrote in message
...
I need a date formula that will insert the date as the
1st of what ever month it is, i.e. in Feb, no matter what
the date is ,it would return 2/1/2004. In Mar it would
always be 3/1/2004.

Any help is appreciated.

DATE = 1ST OF MTH
 

Hi
try
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)

--
Regards
Frank Kabel
Frankfurt, Germany

RONBO wrote:
I need a date formula that will insert the date as the
1st of what ever month it is, i.e. in Feb, no matter what
the date is ,it would return 2/1/2004. In Mar it would
always be 3/1/2004.

Any help is appreciated.

DATE = 1ST OF MTH
 

One way:

=DATE(YEAR(TODAY()),MONTH(TODAY()),1)

In article ,
"RONBO" wrote:

I need a date formula that will insert the date as the
1st of what ever month it is, i.e. in Feb, no matter what
the date is ,it would return 2/1/2004. In Mar it would
always be 3/1/2004.

Any help is appreciated.