How to subtract 2 dates to get number of days.....please
 

I've tried fornatting, to no avail.......I'm on Excel '97.

Cheers

Nick

How to subtract 2 dates to get number of days.....please
 

Hi Nick,

Just subtract the oldest date from the newer one and format the result as General or Number, not Date.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Nick" wrote in message ...
| I've tried fornatting, to no avail.......I'm on Excel '97.
|
| Cheers
|
| Nick
|
|

How to subtract 2 dates to get number of days.....please
 

Nick,

Simple subtraction will work. Excel stores dates internally as numbers.
When one of the cells involved in an arithmetic operation has a certain
format Excel often uses the same format for the output. You have two
options:

=B2-A2
and format the cell as general. Or,

=VALUE(B2-A2)

HTH
Kostis Vezerides


Nick wrote:
I've tried fornatting, to no avail.......I'm on Excel '97.

Cheers

Nick

How to subtract 2 dates to get number of days.....please
 

you could use
=datedif(Date1,Date2,"d")

datedif() is a useful function in EXCEL, but you won't find it in help

"Nick" wrote:

I've tried fornatting, to no avail.......I'm on Excel '97.

Cheers

Nick