EOMONTH
barbarr wrote on December 31, 1969 19:00 EST
I think you need to mention that the Analysis ToolPak Add-In needs to be installed before the EOMONTH() function is available.
If not sure that the Analysis ToolPak Add-In is installed, then the safest formula to use is your second one:
=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
Analysis ToolPak Add-In
jwanegar wrote on December 07, 2005 23:14 EST
You have to be sure anyone viewing your worksheet has the Analysis ToolPak Add-In installed, or that you have converted the formula to values (copy, paste special, values).
Date function use
Deepak wrote on December 31, 1969 19:00 EST
I think in the third formula, if the date in Col. A is December, then using A2+1 is bound to give error. Please clarify on dsugandhi@vsnl.net
Finding the last day of a given month
gms_nm wrote on December 08, 2005 01:25 EST
=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
1. Tried the formula if num_months = 0, it gives the end date for the previous month and if num_months = 1, it gives the end date for the current month
2. To get the EO month the formula should be DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0)
3. The third formula DATE(2005,A2+1,0) does not seem to work
Date function use
MohanaSundaram G wrote on December 31, 1969 19:00 EST
=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
1. Tried the formula if num_months = 0, it gives the end date for the previous month and if num_months = 1, it gives the end date for the current month
2. To get the EO month the formula should be DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0)
3. The third formula DATE(2005,A2+1,0) does seem to work
Date function use
MohanaSundaram G wrote on December 31, 1969 19:00 EST
=DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
1. Tried the formula if num_months = 0, it gives the end date for the previous month and if num_months = 1, it gives the end date for the current month
2. To get the EO month the formula should be DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0)
3. The third formula DATE(2005,A2+1,0) does seem to work
valubale suggestion
roomi wrote on December 31, 1969 19:00 EST
I would request to all those who give excel tips and the ones who post it on this forum to list their tip/suggestion with example. That way it will be a lot easier for less advance excel user to understand the working of it in a real example and than able to apply whenver the face that particular situation.
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
Adventure Capitalist: The Ultimate Road Trip
