Re: $$Excel-Macros$$ Need to find out date

Hi, PFA file for solution. Regards, Swapnil. On Tue, Feb 18, 2014 at 1:41 PM, wrote: > Dear Team, > > I have file where i need to find out when the employee is compelteing 60 > Years. Please refer attached file & Help. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ Need to find out date

Dear Team, I have file where i need to find out when the employee is compelteing 60 Years. Please refer attached file & Help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.co

Re: $$Excel-Macros$$ $$Excel-Macros$$ Need to find out date of latest data

Dear Excel Learner, Thanks for the solutions and sorry for late response. Can you please let me know the logic for 10^10 in below formula =IF(COUNT($G6:$R6),LOOKUP(10^10,$G6:$R6,$G$5:$R$5),"") Regards, Vijayendra 2012/10/8 Ms-Exl-Learner > Hi Vijayendra > > Copy and paste the below formula