I have a spreadsheet with a list of dates in one column that are move-in dates. The other columns are a list of charges of several different catagories. I have a seperate area adding all the values up. The goal of the worksheet is to calculate vacany loss. I would like if it is past the date generated in the worksheet using the TODAY formula, that it exclude those cells and does not add them to the total.
Any help would be greatly appreciated.
nyran, welcome to the forum. This should be relatively straightforward to set up - can you please upload a small sample workbook, so that a solution which fits YOUR data can be provided.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Vacancy Lost.xlsx
Attached is the spreadsheet that I'm trying to use.
Goal being that if the move out date has passed it will not calculate it in the totals on the right.
I have posted the excel workbook. Any suggestions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks