Count days inside 2 dates

  • Thread starter Thread starter Call me Ana, Ana Pego
  • Start date Start date
C

Call me Ana, Ana Pego

Sorry, I have been trying all sorts of different formulas to get this right.
I need a formulae that can calculate the numbers of day in C

A guest arrives on A, left on B, total numbers of days on C.

A B C
10/12/2008 11/12/2008 1 (days)
31/12/2008 03/01/2009 3
Much appreciated!
 
Hi,

Just FYI - you could use =DATEDIF(A1,B1,"d")

but none of us would because =B1-A1 is so much easier. However, the DATEDIF
function has other values for the last argument, here "d", which make it
potentially very useful.
 
Back
Top