On Monday, August 27, 2012 9:49:40 AM UTC-5, ChooseParkay wrote:
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!









--

ChooseParkay

I would probably develop a macro that would use DATE to set the values and then export to wherever desired. All ONE mouse click with no formulas required.