=IF function with current date

[ChooseParkay]

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.
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 o
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()) anywher
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 dat
is left blank (i.e. rentals started 8/1 today is 8/3 it has been
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

 

[Don Guillett]

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!

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.

 

[ChooseParkay]

;1604987']On Monday, August 27, 2012 9:49:40 AM

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

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

 

[Don Guillett]

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!

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