Trying to use IF and TODAY to auto-populate cells in the future. I have tried =IF(TODAY()=M7+K7-O7,Q7,"") but it does not work.
COLUMN C IS POPULATED BY A SEPARATE SHEET IN THE SAME WORKBOOK
COLUMN E IS THE START OF THEIR 12 MONTH HOLIDAY PERIOD i.e. FRED BLOGS PERIOD IS FROM 01/05/2020 TO...