Retirement date - formula

for MS Excel 2007 and higher

Try this formula

=EOMONTH(IF(DAY(C1)=1,DATE(YEAR(C1),MONTH(C1)-1,DAY(C1)),DATE(YEAR(C1),MONTH(C1),DAY(C1))),0)

see attached file 

Thank u very much sir....

Hi, OG sir,

if possible try to do like this,

DOB 01-Mar-1970 means +58 years direct get result  what  we need when the result date is 1st, the month of retirement should be last day of before month. If retirement day is 2nd or more , the date of retirement should be end of the current month. 

Thanks in advance.
 

You mean doing it directly, in this case formula become too long and hard to understand.

One suggestion you can hide column C.

Pls see attached file.

T H A N K     U     V E R Y    M U C H   S I  R

Hi

You can use simply EDATE function:

=EDATE(startDATE , no. of month)

in your case;

=EDATE(1-May-71 , 58*12)

Thanks Vibhav,

simple command!! giving me answer. 

CACLUBINDIA is great yar!!!

hey rilli glad to help..

Cheerz to CCI'tiez!!