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!