first day of the current month

L

Lila

I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

JE McGimpsey

One way:

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

Another:

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

Jim Thomlinson

This requires the analysis toolpack addin (Tools Addins Analysis Toolpack).

=EOMONTH(NOW(), -1)+1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Dates 5
Calculating occupational sick pay entitlement 0
Formula to calculate exact months and days between two dates 3
2 dimensional date sort 2
Return the Date of a certain Day Each Month 2
Day of the week 1
Working Days in a Named Month 1
How many days fall in each month? 4

Top