Change cells to DD/MM/YYYY HH:MM, 1st cell put date and 00:00 for time, 2nd
cell put end date plus 00:00 then this calculation =(B2*24)-(A1*24)
In 4th cell put=(A3/24), then hide column 3. Hope this helps. Thanks John


"stucklady!" wrote:

okay - I would like to be able to calculate the amount of days between 2
dates, eg, 01/01/2004 and 15/06/2007. I need the answer in days. I also
need to know how to add 'x' amount of days to a date, eg 274 days added to
01/01/2005. Cheeries!