I've got a worksheet that I am trying to get it to count months and years and put it in multiple other sheets. I want my employees to put in the information in the Tracking and it count from the Move in date how many were received by the month and by the year in the Lease Count. Then I want the lease count to fill in the lease expiration by it's move in date and lease term. For instance, if someone does a 12 month lease and moves in on 1/1/17, I want it to increase the the January 2017 count by 1, and add 1 to the December 2017 (because it would expire 12/31/17) on the lease expiration.
Am I asking too much?
I have it calculating days in the apartment, as well as cells that find the text from the dates so it can find just the month and just the year for both move in and move out date.
I think I've been looking at this too long.
Bookmarks