Eomonth

[Mr.Jay]

Hi All,

am currently having problems using the EOMONTH function in excel 2003.

this is the formula that my colleague used to have and use but its working for him. when i got the file, everything went haywire!

=IF(J6="","",(EOMONTH(J6,1)))
=IF(L6="","",(EOMONTH(L6,0)))

i dont know what the issue is about

 

[kpark91]

You need to add Analysis Tool Pack.

 

[Mr.Jay]

thanks much

 

[T. Valko]

Hi All,

am currently having problems using the EOMONTH function in excel 2003.

this is the formula that my colleague used to have and use but its working for him. when i got the file, everything went haywire!

=IF(J6="","",(EOMONTH(J6,1)))
=IF(L6="","",(EOMONTH(L6,0)))

i dont know what the issue is about

An alternative to the EOMONTH function:

=IF(J6="","",DATE(YEAR(J6),MONTH(J6)+2,0))

=IF(L6="","",DATE(YEAR(L6),MONTH(L6)+1,0))