Hello,

I am trying to set up a rental sheet that will update the costs daily. These costs are then to be uploaded into our accounting system daily. A simplified version of the sheet looks like this.

....................................=b1-a1
Start Date End Date Total Days
8/17/2012.......................-41138 (I would like a current total of days to be updated daily)
.........................................0
.........................................0
8/17/2012...8/19/2012.....2
8/18/2012......................-41139

The problem is there is no running current date (or =today()) anywhere in the workbook. I am not sure how to set up an IF function that will:

1.) read 0 days when there is no start date

2.) have a current number of days from the start date when the end date is left blank (i.e. rentals started 8/1 today is 8/3 it has been 2 days)

3.) Have a final total of days when the start and end date is filled in

Any help is appreciated. Thank you in advance!