How to Determine the 3 of days between two dates
 

Have to determine the number of days between two dates

exmple: 1/1/98 and 3/31/98 = #days

Thanks
--
Helping Is always a good thing

How to Determine the 3 of days between two dates
 

one way is to use the Int() worksheet function.
A1: 1/15/2007
A2: 1/30/2007
B2: = INT(A2-A1)

Merjet

How to Determine the 3 of days between two dates
 

If in different cells, simply subtract one from the other

--
Don Guillett
SalesAid Software

"QuietMan" wrote in message
...
Have to determine the number of days between two dates

exmple: 1/1/98 and 3/31/98 = #days

Thanks
--
Helping Is always a good thing

How to Determine the 3 of days between two dates
 

And format as General, not as Date (which is what Excel does automatically)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Don Guillett" wrote in message ...
| If in different cells, simply subtract one from the other
|
| --
| Don Guillett
| SalesAid Software
|
| "QuietMan" wrote in message
| ...
| Have to determine the number of days between two dates
|
| exmple: 1/1/98 and 3/31/98 = #days
|
| Thanks
| --
| Helping Is always a good thing
|
|