On Oct 16, 11:58 am, "Ron Coderre"
wrote:
If you have the Analysis ToolPak add-in installed:
try this:
=EOMONTH(TODAY(),-1)+1

If you don't....try this:
=TODAY()-DAY(TODAY())+1

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Geo" wrote in message

...

What formula do I use to give me the begining of the present month.
--
Geo

Try,

format cell with formula =NOW() as Mmm

This will only give you the first 3 character of the month