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!

Assume startdates in A2 down, enddates in B2 down
Then in C2: =B2-A2
Format C2 as general (via FormatCells), then copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Call me Ana, Ana Pego" wrote:
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.

--
Thanks,
Shane Devenshire


"Call me Ana, Ana Pego" wrote:

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!