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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 09:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com