Return 1st of the Month

[Guest]

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.

 

[Bob Phillips]

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

--

HTH

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

 

[Peo Sjoblom]

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

 

[Guest]

=date(year(c4),month(c4),1)
HTH,
Gary Brown

 

[Guest]

=date(year(c4),month(c4),1)
HTH,
Gary Brown

 

[Domenic]

Try...

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

Hope this helps!

 

[Jason Morin]

=SUM(C4,-DAY(C4),1)

HTH
Jason
Atlanta, GA

 

[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.

=c4-day(c4)+1


--ron

 

[Guest]

Thank you all. I now have several options which work.

 

[Guest]

You could also use =eomonth(c4,-1)+1

 

[Guest]

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

 

[Guest]

Sorry - seems to work now, what sure what the problem was earlier.

Cheers,

Matt

 

[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

=A1-DAY(A1)+1

Substitute TODAY() for A1.


--ron