From: Ayo on 22 Mar 2010 11:58 Is there an equivalent function to EOMonth in xl2003 or a formula that will get me the same result? From: Roger Govier on 22 Mar 2010 12:08 Hi Where it would have been =EOMONTH(start_date,months) use =DATE(YEAR(start_date),MONTH(start_date)+months+1,0) -- Regards Roger Govier Ayo wrote:> Is there an equivalent function to EOMonth in xl2003 or a formula that will > get me the same result? From: Jim Thomlinson on 22 Mar 2010 12:17 EOMonth requires the analysis toolpak to be added in which you can do in 2003. That being said you can accomplish the same thing similar to this... With a Date in A1 and the number of months to increment in B1 your EOMonth would look like this: =EOMONTH(A1, B1) Which can be done like this =DATE(YEAR(A1), MONTH(A1) + B1 + 1, 0) which does not require the analysis toolpak and will work in all version of XL. -- HTH... Jim Thomlinson "Ayo" wrote: > Is there an equivalent function to EOMonth in xl2003 or a formula that will > get me the same result? From: Mike H on 22 Mar 2010 12:17 Hi, If you load the analysis toolpak you have EOMONTH in e2003 but here's an alternative non ATP method. Chane the 1 after the month to change the month =DATE(YEAR(A1),MONTH(A1)+1,0) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Ayo" wrote: > Is there an equivalent function to EOMonth in xl2003 or a formula that will > get me the same result? From: Paul C on 22 Mar 2010 12:18 lNot a direct function like EOMonth but =Date(Year(A1),Month(A1)+1,) works When you leave off the day from the inputs Excel picks the last day of the prior month, so when you use Month(A1)+1 you get the last day of the current month. Even works for leap years 2/15/2004 in A1 yields 2/29/2004. Kind of an odd quirk, like it is picking the 0th day of the month. Not sure if this was intentional on the programmers part, but it works. -- If this helps, please remember to click yes. "Ayo" wrote: > Is there an equivalent function to EOMonth in xl2003 or a formula that will > get me the same result?  |  Pages: 1 Prev: convert vcf to xlsNext: multiple correlations with one click?