How can I calculate dates?
 

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

How can I calculate dates?
 

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

--
Gary''s Student - gsnu200737


"Saz" wrote:

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

How can I calculate dates?
 

Thank you Gary....that works perfect.


On Aug 15, 2:56 pm, Gary''s Student
wrote:
=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " &
DATEDIF(A1,B1,"md") & " days"

--
Gary''s Student - gsnu200737



"Saz" wrote:
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- Hide quoted text -

- Show quoted text -

How can I calculate dates?
 

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

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200737


"Saz" wrote:

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

How can I calculate dates?
 

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.)



NURU wrote:

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

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200737


"Saz" wrote:

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



--

Dave Peterson

How can I calculate dates?
 

Thanks!!!

Nuru

"Dave Peterson" wrote:

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.)



NURU wrote:

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

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200737


"Saz" wrote:

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



--

Dave Peterson