| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EOMONTH question
What formula do I use to give me the begining of the present month.
-- Geo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EOMONTH question
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
-- Regards, Peo Sjoblom "Geo" wrote in message ... What formula do I use to give me the begining of the present month. -- Geo |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EOMONTH question
This should do it:
=DATE(YEAR(TODAY()),MONTH(TODAY()),1) HTH, Elkar "Geo" wrote: What formula do I use to give me the begining of the present month. -- Geo |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EOMONTH question
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EOMONTH question
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EOMONTH question
Thank you all very much, they all work.
mmmmm.....which one to choose!!!!!! -- Geo "mohavv" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EOMONTH question
2 different questions. Not sure which you want answered, so you get both.
EOMONTH question EOM can be stated as day zero of the following month: =DATE(YEAR(NOW()), MONTH(NOW())+1, 0) What formula do I use to give me the begining of the present month. BOM can be stated as day one of the current month: =DATE(YEAR(NOW()), MONTH(NOW()), 1) HTH, "Geo" wrote in message ... What formula do I use to give me the begining of the present month. -- Geo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| eomonth | Excel Worksheet Functions | |||
| EOMONTH() question | Excel Worksheet Functions | |||
| Every time I try to use EOMonth I get #Name? | Excel Worksheet Functions | |||
| I'm Having Problems with EOMONTH | Excel Worksheet Functions | |||
| I'm having problems with EOMONTH | Excel Worksheet Functions | |||
Linear Mode
