how do i put formula to find difference between two dates
 

how do i put formula to find difference between two dates

Put in C1: =B1-A1

where
A1 contains the start date, say: 01-May-2005
B1contains the end date, say: 10-May-2005

For the sample dates in A1 and B1, C1 will return: 9
---
Pl post your question within the message area in future.
The "Subject" line is meant only for some key words/descripts, not to house
your *entire* post
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"A.D" wrote in message
...

Format the answer as General.
Bob Umlas
Excel MVP

"Max" wrote in message
...
how do i put formula to find difference between two dates

Put in C1: =B1-A1

where
A1 contains the start date, say: 01-May-2005
B1contains the end date, say: 10-May-2005

For the sample dates in A1 and B1, C1 will return: 9
---
Pl post your question within the message area in future.
The "Subject" line is meant only for some key words/descripts, not to
house
your *entire* post
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"A.D" wrote in message
...

"Bob Umlas" wrote
Format the answer as General.

Thanks for the add-on, Bob !

I must have done up the formula in C1 first,
followed by the test date inputs in A1 and B1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----