Return 1st of the Month

J

JJalomo

I need a formula or function which will return the first of the month. For
example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4.

Cell c4 can contain any date.
 
B

Bob Phillips

=date(year(c4),month(c4),1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

Ron Rosenfeld

I need a formula or function which will return the first of the month. For
example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4.

Cell c4 can contain any date.
Click to expand...

=c4-day(c4)+1


--ron
 
M

Matt D Francis

Sorry to intrude, I need a similar function but will always return the start
date of the CURRENT month - i.e date sheet is opened? I tried using TODAY()
in place of C4 in this formula but no luck - any suggestions?

Matt
 
R

Ron Rosenfeld

Sorry to intrude, I need a similar function but will always return the start
date of the CURRENT month - i.e date sheet is opened? I tried using TODAY()
in place of C4 in this formula but no luck - any suggestions?

Matt
Click to expand...


=A1-DAY(A1)+1

Substitute TODAY() for A1.


--ron
 
Top