How can I calculate dates?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Saz - 15 Aug 2007 20:44 GMT

Hi,

I have to find out how old is the past date from today's date? Example
- Date of birth (A1) = 01/01/1978 and today's date (B1) = 08/15/07 so
on C1 (B1-A1) = ?

Thank you,
Sajan

Reply to this Message

Gary''s Student - 15 Aug 2007 20:56 GMT

=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " &
DATEDIF(A1,B1,"md") & " days"

Signature

Gary''s Student - gsnu200737

> Hi,
>
[quoted text clipped - 4 lines]
> Thank you,
> Sajan

Reply to this Message

Saz - 15 Aug 2007 21:18 GMT

Thank you Gary....that works perfect.

On Aug 15, 2:56 pm, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:

> =DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " &
> DATEDIF(A1,B1,"md") & " days"
[quoted text clipped - 12 lines]
>
> - Show quoted text -

Reply to this Message

NURU - 24 Aug 2007 13:16 GMT

Beautiful! However, I could not see the function(s) you used in the Excel
(2003) function List to enable me get more information. Is it DATE and DIF,
or DATED and IF, or am I on the wrong lane?

Nuru

> =DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " &
> DATEDIF(A1,B1,"md") & " days"
[quoted text clipped - 7 lines]
> > Thank you,
> > Sajan

Reply to this Message

Dave Peterson - 24 Aug 2007 13:52 GMT

Oddly, =datedif() only appears in xl2k's help.

Chip Pearson has some very nice notes:
http://www.cpearson.com/excel/datedif.htm

(Short for date-difference, I bet.)

> Beautiful! However, I could not see the function(s) you used in the Excel
> (2003) function List to enable me get more information. Is it DATE and DIF,
[quoted text clipped - 16 lines]
> > > Thank you,
> > > Sajan

Signature

Dave Peterson

Reply to this Message

NURU - 24 Aug 2007 15:24 GMT

Thanks!!!

Nuru

> Oddly, =datedif() only appears in xl2k's help.
>
[quoted text clipped - 23 lines]
> > > > Thank you,
> > > > Sajan

Reply to this Message