Hi
no need to shout (typing in all caps in ngs is generally considered to be
shouting) ... if you have 1/1/04 in cell A1 and 2/3/05 in cell B1 then in
cell C1 type
=B1-A1
you may then have to right mouse click on C1, choose format cells, on the
numbers tab choose general to get the answer displayed as a number rather
than a funny date.
Cheers
JulieD
"WINONA" wrote in message
...
WE ARE TRYING TO CALCULATE HOW MANY DAYS. EXAMPLE, FROM 1/1/04 TO 2/3/05
HOW
MANY DAYS IS THAT. IS THERE A FORMULA THAT CAN DO THIS
|