| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Datedif
A1 has a hire date and I want to find the difference in days/years between A1
and a specific date (10/21/1994). I'm not very familiar with date functions, can someone help me? -- Thanks! -Jennifer |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Datedif
As a worksheet function???
Take a look at Chip Pearson's site for =DateDif() http://www.cpearson.com/excel/datedif.htm Jennifer wrote: A1 has a hire date and I want to find the difference in days/years between A1 and a specific date (10/21/1994). I'm not very familiar with date functions, can someone help me? -- Thanks! -Jennifer -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Datedif
Yes, as a worksheet function ( I think ? )
I've looked on that site and can't follow the information (my lack of excel knowledge) I need it spelled out for me, Sorry. -- Thanks! -Jennifer "Dave Peterson" wrote: As a worksheet function??? Take a look at Chip Pearson's site for =DateDif() http://www.cpearson.com/excel/datedif.htm Jennifer wrote: A1 has a hire date and I want to find the difference in days/years between A1 and a specific date (10/21/1994). I'm not very familiar with date functions, can someone help me? -- Thanks! -Jennifer -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Datedif
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & "months, "
& DATEDIF(A1,NOW(),"md") & " days" This will return a string like 33 years, 9 months, 18 days Copied from Chip's site. =DATEDIF(DATE(1994,10,21),A1,"y") & " years, " & DATEDIF(DATE(1994,10,21),A1,"ym") & "months, " & DATEDIF(DATE(1994,10,21),A1,"md") & " days" Jennifer wrote: Yes, as a worksheet function ( I think ? ) I've looked on that site and can't follow the information (my lack of excel knowledge) I need it spelled out for me, Sorry. -- Thanks! -Jennifer "Dave Peterson" wrote: As a worksheet function??? Take a look at Chip Pearson's site for =DateDif() http://www.cpearson.com/excel/datedif.htm Jennifer wrote: A1 has a hire date and I want to find the difference in days/years between A1 and a specific date (10/21/1994). I'm not very familiar with date functions, can someone help me? -- Thanks! -Jennifer -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATEDIF? | Excel Discussion (Misc queries) | |||
| Datedif | Excel Worksheet Functions | |||
| Datedif() | Excel Discussion (Misc queries) | |||
| DateDIF | Excel Programming | |||
| DateDif Average? Damn DateDif | Excel Worksheet Functions | |||
Linear Mode
