|
|
|
|
|
|
|
|
|
|
| |
Note that this gives nonsense answers when the beginning month is longer
than the end month:
on 1 March 2006, this formula will, for
A1: 31 January 1988
return "17 years, 1 months, -2 days"
Since you don't need the days, better to ditch the extra functions and
use
=DATEDIF(A1, TODAY(), "y") & " years old"
or,
=IF(DATEDIF(A1,TODAY(),"y")>=18,"OK","Too young")
(You could use NOW(), instead, but adding the time doesn't matter with
DATEDIF)
In article <#mdcNcKYFHA.1152@tk2msftngp13.phx.gbl>,
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote:
> =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
> DATEDIF(A1,NOW(),"md") & " days"
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
in excel i want to calculate days between two dates
for e. g.
16/10/2008 minus 14/08/2008
(dd/mm/yyyy)
please explain and if possible give me an example.
my alernate email address is
rajmkapadia@gmai.com
please help me out
thanks
=raj kapadia, surat, india
"Bob Phillips" wrote:
> =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
> DATEDIF(A1,NOW(),"md") & " days"
> --
>
> HTH
>
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Pate" <Pate@discussions.microsoft.com> wrote in message
> news:C3AC0970-ACEF-41E1-9D13-F776891DDD33@microsoft.com...
> > We are using Excel as a manual log of visits. We would like to screen out
> > anyone that is not 18 years old and were looking for a means of
> calculating
> > the age from the current date and the date of birth. Is there a function
> that
> > can do this?
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Yes you got it right in saying "16/10/2008 minus 14/08/2008".
If your dates are in A2 and B2 respectively, the formula for the number of
days is =A2-B2. The explanation is that Excel dates are stored as a number
of days from an origin at the start of 1900 (or of 1904, depending on which
options you have set).
Note that when you ask a question in a newsgroup, the answer comes in the
newsgroup, not by e-mail. The reason for that is so that the answer can be
of use to other readers of the group (and so that other contributors can
correct me when I've got it wrong).
--
David Biddulph
"RAJ KAPADIA, SURAT, INDIA" <RAJ KAPADIA, SURAT,
INDIA@discussions.microsoft.com> wrote in message
news:B1BBC7A9-6920-4FDB-935E-D92F7CF197E1@microsoft.com...
> in excel i want to calculate days between two dates
>
> for e. g.
>
> 16/10/2008 minus 14/08/2008
> (dd/mm/yyyy)
>
> please explain and if possible give me an example.
>
> my alernate email address is
>
> rajmkapadia@gmai.com
>
> please help me out
>
> thanks
>
> =raj kapadia, surat, india
>
> "Bob Phillips" wrote:
>
>> =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months,
>> " &
>> DATEDIF(A1,NOW(),"md") & " days"
>> --
>>
>> HTH
>>
>>
>> RP
>> (remove nothere from the email address if mailing direct)
>>
>>
>> "Pate" <Pate@discussions.microsoft.com> wrote in message
>> news:C3AC0970-ACEF-41E1-9D13-F776891DDD33@microsoft.com...
>> > We are using Excel as a manual log of visits. We would like to screen
>> > out
>> > anyone that is not 18 years old and were looking for a means of
>> calculating
>> > the age from the current date and the date of birth. Is there a
>> > function
>> that
>> > can do this?
>>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Question
Answer
Notify me of replies