| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate dates | Excel Worksheet Functions | |||
| calculate dates | Excel Discussion (Misc queries) | |||
| How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions | |||
| How do I calculate an age from 2 dates? | Excel Worksheet Functions | |||
| How do I calculate dates? | Excel Worksheet Functions | |||
Linear Mode
