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
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
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
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