I am building a spreadsheet to calculate dates and expense.. IE. I place a rental building on a location on 01/01/2001 and it is there until 01/28/2001. I charge $70 a day for it.
I currently have
Column 1 : Shack ID
Column 2: Start Date
Column 3: End Date
Column 4: Total Days
Then at the very end of Column 4 it calculates the # of days multiplied by the Charge per Day, so I that automatically know the revenue generated by the building. Problem I am having is. When Column 2 and 3 are empty column 4 results "0" which is fine with me. But IF only one of the columns, Column 2 or Column 3 have a date entered, Column 4 shows something similar to "47853" and completely screws up the Formula at the bottom of Column 4 calculating the revenue.
I know i've done this before, but I absolutely have racked my brain and Can't remember how to make it quit doing that. Any help is greatly appreciated.
Thanks All!
Bookmarks