I am looking to check if the values are on the given quarter in a table
In the attached table, the dates are on the start and complete date and the it has the estimate amount of expenditure for each quarter. The quarter, like Nov-16 means it ends on Nov-16 starting from Sep-17.
So, for col 25, (Delivery) - should start at Oct16 to Feb-18 but as the value on the columns ends on Nov-17 (one quarter short) the value in Q25 should give false.
How to setup a formula for this.
Thanks in advance for your help.
Bookmarks