Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Final day of month
Am trying to allow someone to set a bill day of 30 or 31, and then create a
calendar that changes this to the last day of the respective month. EOMONTH does not work. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Final day of month
"B" wrote...
Am trying to allow someone to set a bill day of 30 or 31, and then create a calendar that changes this to the last day of the respective month. EOMONTH does not work. Always best to be specific about HOW something doesn't work. Did Excel return an error value or the wrong result? If it returned the error value #NAME?, then the most likely reason is that you haven't enabled the Analysis ToolPak add-in. It's NOT enabled by default. See online help for the EOMONTH function for directions on what you'd need to do. In future, you may find it quicker to check online help first. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Final day of month
Last day of what month, do you mean if you have a date in A1 like 05/10/07
then you want to add 30 days and then get the last date of the months? if the date was 05/10/07 it would be 06/30/07? =DATE(YEAR(A1+30),MONTH(A1+30)+1,0) I am sure EOMONT is working if you have ATP installed =EOMONTH(A1+30,0) -- Regards, Peo Sjoblom "B" wrote in message ... Am trying to allow someone to set a bill day of 30 or 31, and then create a calendar that changes this to the last day of the respective month. EOMONTH does not work. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Final day of month
Hi
Without using the Analysis Toolpak function EOMONTH, you could use =DATE(YEAR(TODAY()),MONTH(TODAY())+1,0) to always give the last day of the current month. -- Regards Roger Govier "B" wrote in message ... Am trying to allow someone to set a bill day of 30 or 31, and then create a calendar that changes this to the last day of the respective month. EOMONTH does not work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Final #DIV/0! that I'd like to say Goodbye to! | Excel Worksheet Functions | |||
Get final non-blank cell in range | Excel Worksheet Functions | |||
How do I figure out a pre-tax amount when I know the final total? | Excel Worksheet Functions | |||
summarise totals from many worksheets into one final worksheet | Excel Worksheet Functions | |||
How do I calculate the final pmt required to meet a target IRR? | Excel Worksheet Functions |