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)
 
G

Guest

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

Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Return the Date of a certain Day Each Month 2
Day of the week 1
check for last day of month 11
Lousy routine to get the first available day of the month 2
Excel Message box with days of month & date. 1
Hide the current month columns 9
Macro for Dates 5

Top