Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using datedif formula
I am using a datedif formula to calculate an employee's number of years
worked. I have the hire date and current(sheet) date. I have used the formula =datedif(cellwithcurrentdate,cellwithhiredate,"y") . The return is 1/17/1900. What am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using datedif formula
You aren't doing anything wrong... that is just Excel trying to be helpful
(it saw you working with dates, so it gave you its answer as a date)... just Format the cell to General and it will report 17 as the result. -- Rick (MVP - Excel) "marie" wrote in message ... I am using a datedif formula to calculate an employee's number of years worked. I have the hire date and current(sheet) date. I have used the formula =datedif(cellwithcurrentdate,cellwithhiredate,"y") . The return is 1/17/1900. What am I doing wrong? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using datedif formula
I would have expected an error, as (assuming that hire date is in the past)
the syntax would be =datedif(cellwithhiredate,cellwithcurrentdate,"y") not not =datedif(cellwithcurrentdate,cellwithhiredate,"y") -- David Biddulph "Rick Rothstein" wrote in message ... You aren't doing anything wrong... that is just Excel trying to be helpful (it saw you working with dates, so it gave you its answer as a date)... just Format the cell to General and it will report 17 as the result. -- Rick (MVP - Excel) "marie" wrote in message ... I am using a datedif formula to calculate an employee's number of years worked. I have the hire date and current(sheet) date. I have used the formula =datedif(cellwithcurrentdate,cellwithhiredate,"y") . The return is 1/17/1900. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Datedif() | Excel Discussion (Misc queries) | |||
Datedif formula | Excel Discussion (Misc queries) | |||
about this formula =DATEDIF(J5,H5,"d") | Excel Discussion (Misc queries) | |||
DATEDIF formula enhancement | Excel Worksheet Functions | |||
DateDif Average? Damn DateDif | Excel Worksheet Functions |