Re: $$Excel-Macros$$ Date formula complicated Challengeing Required

2018-05-04 Thread amar takale
Any Solution? On Mon, Apr 30, 2018 at 7:29 PM, amar takale wrote: > > -- > 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.com/discussexcel > > FORUM RULES > > 1) Use concise, acc

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-08 Thread amar takale
Dear Mandeep Very Helpful and thanks providing this helpful knowledge regarding date solution. And Thank you very much for all Regards Amar On Mon, Feb 8, 2016 at 3:06 PM, Mandeep baluja wrote: > Hey Amar, >> > > While doing manipulations with date you must ensure the Format of System

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-08 Thread Mandeep baluja
> > Hey Amar, > While doing manipulations with date you must ensure the Format of System date format.Some people use mm/dd/ and others use dd/mm/ so if someone has provide you the data in his format and you'r date format is different from that it will shows you the error. Note one t

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-07 Thread amar takale
Dear all thanks for reply but i cant understand what you say.I except only date formula in column D. On Sun, Feb 7, 2016 at 9:36 PM, GENIUS wrote: > LOOK AT THE ATTACHMENT > > -- > 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 Fac

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-07 Thread GENIUS
LOOK AT THE ATTACHMENT -- 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.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-06 Thread big smile
This is 1 st time i am sending other query's reply. Otherwise i am always sending query only. Thank you very much Check this file too. It may also help you & our group too .. You can add days also in today' s date If u think to have some more correction & then let me know On 6 February 2016

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-06 Thread Abhishek Jain
Look at the second name "Carme" in your sheet. Your formula is picking up the first 02 digits of the DOB and taking them as 'month' and there is no 16th month in the calender. You either need to change your formula or the dates themselves. HTH On Sat, Feb 6, 2016 at 2:50 PM, amar takale wrote:

Re: $$Excel-Macros$$ Date Formula

2011-07-26 Thread Nikhil Shah
Dear Haseeb Thanks For Excellent Logic.. Your logic is difference from Daniel. Can you tell why you are not using DATEDIF formula ? Your answer is also right.. Nikhil On Wed, Jul 27, 2011 at 12:13 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Nikhil, > > See the attach

Re: $$Excel-Macros$$ Date Formula

2011-07-26 Thread Nikhil Shah
Hi Daniel Thanks for solving my problem. Nikhil Shah On Tue, Jul 26, 2011 at 5:01 PM, Daniel wrote: > Hello, > > ** ** > > Have a look at the attached workbook. > > ** ** > > Regards. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-mac

Re: $$Excel-Macros$$ Date Formula

2011-07-26 Thread XLS S
for month end date ... =DATE(YEAR(A1),1+MONTH(A1),1)-1 On Tue, Jul 26, 2011 at 12:28 AM, Nikhil Shah wrote: > Dear All Members > > Here I am posting my Question : > > ( 1 ). Starting Date : 25/08/2012 : Format will be dd/mm/ > ( 2 ). End Date : 05/05/2016 : Format will be dd/mm/ > > Now

RE: $$Excel-Macros$$ Date Formula

2011-07-26 Thread Daniel
Hello, Have a look at the attached workbook. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nikhil Shah Envoyé : lundi 25 juillet 2011 20:58 À : excel-macros@googlegroups.com Cc : Maries waran Objet : $$Excel-Macros$$ Date For