Formula issue - IF Statement between 2 dates
I have input a formula to calculate a monthly revenue figure for an annual subscription charge (i.e. divide the subscription charge by 12 between the dates 01/10/2018 - 30/09/2019. I used an =IF(AND...) formula however it is only picking up Oct - Dec of every year rather than Oct 2018 - Sept 2019. I can't figure out what is wrong, other than potentially date format but all date cells are linked to the same input sheet.
Help Article Resources
Check out the Formula Handbook template!