Forum Discussion
Counting Dates and Linking Sheets within One Workbook
This is a 2 part question
I am currently working with a spreadsheet that I would like to total by monthly expiration date and then total how many are expiring or expired based on a certain color (red for expired and yellow for expiring) and contract number.
Then I need to take the totals and have them automatically update from the master sheet to the correct sheet for the specific contract this pertains to. I have tried the SUM, SUMIF, COUNT, COUNTIF, TOTAL, TOTALIF and IF commands but have had no luck.
Here is what the data looks like
| Contract | CGL | Auto | Umbrella/ Excess | Data Breach | E&O |
| 123456 | 7/31/2017 | 7/31/2017 | 7/31/2017 | ||
| 123456 | 11/7/2017 | 11/15/2017 | 11/7/2017 | ||
| 123456 | 4/1/2017 | 4/1/2017 | 4/1/2017 | 4/1/2017 | |
| 123456 | 4/1/2017 | 4/1/2017 | 4/1/2017 | ||
| 123456 | 2/12/2018 | 2/12/2018 | 2/12/2018 | ||
| 123456 | 7/1/2017 | 7/1/2017 | 7/1/2017 | ||
| 123456 | 6/16/2017 | 3/25/2017 | 6/16/2017 | ||
| 123456 | 5/11/2017 | 5/11/2017 | 5/11/2017 | 8/8/2017 | |
| 123456 | 5/19/2017 | 6/5/2017 | 5/19/2017 | 5/19/2017 | |
| 123456 | 1/24/2018 | 1/24/2018 | 1/24/2018 | ||
| 123456 | 10/1/2017 | 10/1/2017 | 10/1/2017 | 10/1/2017 | |
| 123456 | 3/1/2018 | 3/1/2018 | 3/1/2018 | 3/1/2018 | |
| 123456 | 2/7/2018 | 2/7/2018 | 2/7/2018 | 4/24/2017 | |
| 123456 | 12/31/2017 | 12/31/2017 | None | 12/31/2017 | |
| 123456 | 3/5/2018 | 3/5/2018 | 3/5/2018 | 3/5/2018 |
Thank you in advance for any help that can be given.
No RepliesBe the first to reply
