I have two date fields.
I have a calculated field which finds out whether one of these date fields is greater than the other (to see whether I am 'within deadline').
I wish to subtotal the number of instances that are within deadline (within another 'colour' field) - e.g. Blue has 2 instances.
Workbook is attached.
Thanks!
Bookmarks