R Ron Coderre Oct 15, 2007 #4 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)
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)
M mohavv Oct 16, 2007 #5 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) Click to expand... Try, format cell with formula =NOW() as Mmm This will only give you the first 3 character of the month
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) Click to expand... Try, format cell with formula =NOW() as Mmm This will only give you the first 3 character of the month
G George Nicholson Oct 17, 2007 #7 2 different questions. Not sure which you want answered, so you get both. EOMONTH question Click to expand... 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. Click to expand... BOM can be stated as day one of the current month: =DATE(YEAR(NOW()), MONTH(NOW()), 1) HTH,
2 different questions. Not sure which you want answered, so you get both. EOMONTH question Click to expand... 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. Click to expand... BOM can be stated as day one of the current month: =DATE(YEAR(NOW()), MONTH(NOW()), 1) HTH,
