firts day of current month

[sedgely]

i know i've seen this somewhere, but can't find it now...
whats the formula to return the date for the first day of the current month in an Excel cell?

Cheers, Craig
Si fractum non sit, noli id reficere

 

[xlbo]

=Value("01/"&month(today())&"/"&year(today()))

format as dd/mm/yy or whatever date format you want

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[mbarron]

Another option.

=TODAY()-DAY(TODAY())+1

Mike

 

[macropod]

And yet another:

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

So many ways to skin the cat ...

 

[sedgely]

Thanks all
All good answers,mbarrons is the least typing so it looks like i'll use that one.
Thanks again

Cheers, Craig
Si fractum non sit, noli id reficere