Calculating dates problem

[Guest]

Hello,

I use Excel 2000 and have a problem calculating the number of days between
two dates.

I insert both dates in separate cells, both cells containing the same date
format, and when I try using "Paste Function" -> "Date & Time" -> "DAYS360" I
get a windows in which I'm supposed to state the cell that defines the
starting date and the cell that defines the ending date.

The thing is, that when I click on said cells, the "number" word next to the
"Start_date", or the "End_date" changes to "#VALUE".

My Office 2000 has all of the recent updates installed. Where's the problem,
then?

Thanks,

-Dany

 

[Frank Kabel]

Hi
why not use
=A2-A1
and format as number

 

[Guest]

It didn't help...

I tried doing the reduction between the cells, but all I got was #VALUE.
I'm sure the problem is specificaly on this computer, since both your answer
and the "Paste Function" work perfectly fine on other computers.

 

[Guest]

Hi Dany,

Just make sure that you are entering the date according to the system date
format. Select the ‘Regional and Language option’ (if you are using windows
XP, in 98 it is “Regional Settingsâ€) from the control panel and check the
Short date format. If it is not in the same format which you are using in the
excel sheet (I mean “dd-mm-yy†or “mm-dd-yyâ€), change it.

I hope it will solve your problem.

Regards,

Premod

 

[Frank Kabel]

Hi
then probably your values are not real date values but stored as
'Text'. What does the following formula return
=ISNUMBER(A1)

 

[Guest]

That was it!!!

Thanks a lot for the help! It worked like a charm.

-Dany