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
>
> 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
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
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,
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
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:
Dear All
Here I required Date formula for Age Calculation but in cell date there are
some issue Value or text cell format,I cant understand. pls look matter,i
try it helper column but some date issue again.
Pls provide Date formula without helper column
Regards
Amar
--
Are you =EXP(E:RT) or =N