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!

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.

I'm not sure I'm following you on this one. Could you please explain more of how to use a macro with a date function?

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

Send file to dguillett1 @gmail.com with a complete explanation and this msg