Column A has start dates, column B has completion dates (some cells empty)
Need a summary table that calculates:
Projects finished within 1 month:
Within 2 months:
I tried =COUNTIFS(B5:B7,("<"&((A5:A7)+30))) but no luck! It works for just one sell, but not a range unfortunately.
Thank you for any help!
It's better to upload & attached an example sheet. It's hard to understand what you exactly wanna do.
It won't let me upload an attachment weirdly.
Essentially:
example.PNG
I want the yellow to be a formula that if its within 30 days, 60, 90 of the finish-start date to count.
Last edited by kngo; 12-12-2018 at 03:39 PM.
In F2
Formula:
Please Login or Register to view this content.
F3
Formula:Please Login or Register to view this content.
F4
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks