I'm trying to get a very simple DATADIF formula to work. I subtracted the
start date from the end date of each employee to get the total number of days
they were employed. This works fine for dates after 1900, but anything from
the 1700 or 1800's results in a value error. Is there any way I can trick
excel into calculating these values?
Thanks.

Look here:

http://j-walk.com/ss/excel/files/xdate.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"clueless in nj" <(E-Mail Removed)> wrote in message
news:70670C92-6568-46D3-8A0D-(E-Mail Removed)...
| I'm trying to get a very simple DATADIF formula to work. I subtracted the
| start date from the end date of each employee to get the total number of days
| they were employed. This works fine for dates after 1900, but anything from
| the 1700 or 1800's results in a value error. Is there any way I can trick
| excel into calculating these values?
| Thanks.

Also, answer in your other post - please do not multi-post.

Pete

On Dec 9, 8:36 pm, clueless in nj
<cluelessi...@discussions.microsoft.com> wrote:
> I'm trying to get a very simple DATADIF formula to work. I subtracted the
> start date from the end date of each employee to get the total number of days
> they were employed. This works fine for dates after 1900, but anything from
> the 1700 or 1800's results in a value error. Is there any way I can trick
> excel into calculating these values?
> Thanks.

"clueless in nj" wrote:

> I'm trying to get a very simple DATADIF formula to work. I subtracted the
> start date from the end date of each employee to get the total number of days
> they were employed. This works fine for dates after 1900, but anything from
> the 1700 or 1800's results in a value error. Is there any way I can trick
> excel into calculating these values?
> Thanks.

"Niek Otten" wrote:

> Look here:
>
> http://j-walk.com/ss/excel/files/xdate.htm
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "clueless in nj" <(E-Mail Removed)> wrote in message
> news:70670C92-6568-46D3-8A0D-(E-Mail Removed)...
> | I'm trying to get a very simple DATADIF formula to work. I subtracted the
> | start date from the end date of each employee to get the total number of days
> | they were employed. This works fine for dates after 1900, but anything from
> | the 1700 or 1800's results in a value error. Is there any way I can trick
> | excel into calculating these values?
> | Thanks.
>
>
>