Re: $$Excel-Macros$$ Date of Retirement.

2014-02-20 Thread karunanithi ramaswamy
Hi, Use 'End of month' formula and add 720or whatever number of months to find the date of retirement.(Usually retirement happens at the last day of the month) - r.karunanithi. On Wednesday, February 19, 2014 4:29 PM, "prabhakar_k...@sify.com" wrote: thanks its working fine On Tuesday, Febr

Re: $$Excel-Macros$$ Date of Retirement.

2014-02-19 Thread prabhakar_kavi
thanks its working fine On Tuesday, February 18, 2014 9:59:44 PM UTC+5:30, Mahesh wrote: > > Hi Prabhakar > > perhaps you can use, > =DATE(YEAR(H2)+60,MONTH(H2),DAY(H2)) > > Regards > Mahesh > > > On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara > > > wrote: > >> Dear Prabhakar, see the attached

Re: $$Excel-Macros$$ Date of Retirement.

2014-02-18 Thread Mahesh Parab
Hi Prabhakar perhaps you can use, =DATE(YEAR(H2)+60,MONTH(H2),DAY(H2)) Regards Mahesh On Tue, Feb 18, 2014 at 3:54 PM, Ashish Bhalara wrote: > Dear Prabhakar, see the attached file to know the retire age as per your > example > > > On Tue, Feb 18, 2014 at 2:50 PM, wrote: > >> Hi Team, >> >> I

Re: $$Excel-Macros$$ Date of Retirement.

2014-02-18 Thread Ashish Bhalara
Dear Prabhakar, see the attached file to know the retire age as per your example On Tue, Feb 18, 2014 at 2:50 PM, wrote: > Hi Team, > > I need your help to find out date of retirement with simple formula in > attached excel file. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y