Could anyone help me with (Today function), please?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

azik - 30 Dec 2004 00:29 GMT

I got exercise asking to enter formula to compute "the years of service"
using "=(Today()-E2)/365" formula in cell "D2" in table where :
cell E2 is Hire Date 11/24/93 and cell D2 is empty.
Everytime i enter formula it keeps giving error result #VALUE.
I'd be glad if somebody could help me to solve this problem by guiding me
through?
Thank you for your help in advance.

Reply to this Message

Gord Dibben - 30 Dec 2004 00:49 GMT

azik

You would get the error if E2 did not contain a valid date.

In a cell enter =ISNUMBER(E2)

If not a date it will return FALSE.

Re-enter the date in E2 in the proper order for your Regional Settings.

My settings would require me to enter it as dd/mm/yy

Gord Dibben Excel MVP

>I got exercise asking to enter formula to compute "the years of service"
>using "=(Today()-E2)/365" formula in cell "D2" in table where :
[quoted text clipped - 3 lines]
>through?
>Thank you for your help in advance.

Reply to this Message

azik - 30 Dec 2004 02:23 GMT

Hi,
I did exactly as you said , but i still get error "#VALUE" and after I spent
another 2 hours just to find out the error , no result. Don't want to be
sticky but if you got any other solution for these , could you let me know ,
please.

> azik
>
[quoted text clipped - 17 lines]
> >through?
> >Thank you for your help in advance.

Reply to this Message

Dave Peterson - 30 Dec 2004 02:33 GMT

When you used
=ISNUMBER(E2)
Did you get True or False back?

If you got True, then I don't have a suggestion.

But if you got False back, try entering the date one more time in E2.

Maybe spell it out to enter it: November 24, 1993
and reformat the cell to mm/dd/yy.

> Hi,
> I did exactly as you said , but i still get error "#VALUE" and after I spent
[quoted text clipped - 23 lines]
> > >through?
> > >Thank you for your help in advance.

Signature

Dave Peterson

Reply to this Message

Ken Wright - 30 Dec 2004 09:16 GMT

I'd use CTRL+; to enter a date and then edit that - That way you can be sure it
is in the correct format etc for your settings.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> When you used
> =ISNUMBER(E2)
[quoted text clipped - 34 lines]
>> > >through?
>> > >Thank you for your help in advance.

Reply to this Message

azik - 30 Dec 2004 14:09 GMT

Hi, everybody

Finally I managed to sort it out . As you advised , I started exercise from
the begining and this time I formatted date to UK style. And it worked.
I'll will use this forum from now on. Very usefull.
Thank you very much for your help.

Reply to this Message