How do you display the first day of a given month using the today() function

**john dalton** · 06-19-2013, 04:33 AM

Hi,

I am looking to display the first date of a month using the today() function is there a way?

thanks in advance

**Ace_XL** · 06-19-2013, 04:35 AM

Do you mean

=EOMONTH(TODAY(),-1)+1
or
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)

**benishiryo** · 06-19-2013, 04:36 AM

hi john, try:
=TODAY()-DAY(TODAY())+1

in Excel 2003, you might not have EOMONTH
=EOMONTH(TODAY(),-1)+1

**:) Sixthsense :)** · 06-19-2013, 04:39 AM

I posted the same approach, so self deleted

**Kyle123** · 06-19-2013, 05:00 AM

I use this, because my formulas are rubbish and I find it the easiest to understand

=DATEVALUE("01/" & TEXT(TODAY(),"mm/yyyy"))

**john dalton** · 06-19-2013, 07:42 AM

Thank you that works great.

JD

Re: How do you display the first day of a given month using the today() function