how do i put formula to find difference between two dates

  • Thread starter Thread starter Guest
  • Start date Start date
Re: 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
 
Bob Umlas said:
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
 
Back
Top