G
Guest
What formula do I use to give me the begining of the present month.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
G
Guest
This should do it:
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
HTH,
Elkar
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
HTH,
Elkar
R
Ron Coderre
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)
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)
M
mohavv
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)
Try,
format cell with formula =NOW() as Mmm
This will only give you the first 3 character of the month
G
Guest
Thank you all very much, they all work.
mmmmm.....which one to choose!!!!!!
mmmmm.....which one to choose!!!!!!
G
George Nicholson
2 different questions. Not sure which you want answered, so you get both.
=DATE(YEAR(NOW()), MONTH(NOW())+1, 0)
=DATE(YEAR(NOW()), MONTH(NOW()), 1)
HTH,
EOM can be stated as day zero of the following month:EOMONTH question
=DATE(YEAR(NOW()), MONTH(NOW())+1, 0)
BOM can be stated as day one of the current month:What formula do I use to give me the begining of the present month.
=DATE(YEAR(NOW()), MONTH(NOW()), 1)
HTH,