DATE = 1ST OF MTH

[RONBO]

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.

 

[Chip Pearson]

Use the following formula:

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


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

 

[Frank Kabel]

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

 

[JE McGimpsey]

One way:

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