Trying to use IF and TODAY to auto-populate cells in the future.

[Deadagain]

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 30/04/2021
COLUMN G IS AUTOMATICALLY POPULATED BY A SEPARATE SHEET IN THE SAME WORKBOOK
COLUMN I SHOWS THE CURRENT + OR - BALANCE OF THEIR ETITLEMENT ANY DEFICIT IS TAKEN FROM NEXT YEARS ENTITLEMENT AND ANY SURPLUS IS ADDED TO THEIR NEXT YEAR ENTITLEMENT
COLUMN K.THIS NEEDS TO BE POPULATED WHEN THE DATE IN COLUM M IS REACHED, POPULATION COMES FROM COLUMN C WHICH IS AUTOMATICALLY UPDATED FROM ANOTHER SHEET
COLUMN K IS WHERE THE PROBLEM STARTS! WE USE A 2 YEAR CALANDER TO ALLOW A FULL 12 MOTH ENTRY FOR EACH INDIVIDUAL AS THEY ALL HAVE DIFFERENT HOLIDAY START AND END PERIODS. THIS ACTION SHOULD ONLY BE PERFORMED ONCE.
COLUMN M SHOWS THE START OF THEIR NEXT HOLIDAY ENTITLEMENT PERIOD, THIS IS AUTOMATICALLY POPULATED.
COLUMN O IS AUTOMATICALLY POPULATED BY A SEPARATE SHEET IN THE SAME WORKBOOK
COLUMN Q SHOWS THEIR REMAINING BALANCE FOR THE 2021 HOLIDAY ENTITLEMENT PERIOD. AFTER THE INITIAL POPULATION, THIS SHOULD ONLY BE UPDATED BY COLUMN O
COLUMN Q NEEDS TO BE POPULATED ON THE 1ST DAY OF THEIR NEW ENTITLEMENT PERIOD INCLUDING AMENDMENTS BASED ON THEIR BALANCE ON THE LAST DAY OF THEIR 2020 ENTITLEMENT PERIOD (TAKEN FROM COLUMN I)
THEIR BALANCE AND BOOKED TIME IS PICKED UP BY THE DASHBOARD AT THE FRONT OF THE EXISTING WORKBOOK

I HAVE TRIED USING AN IF and TODAY FORMULA TO ACHIEVE THE REQUIRED FIGURES IN COLUMNS K AND Q BUT THIS IS PROOVING TO BEYOND MY CAPABILITIES WITH EXCEL .MY ATTEMPT WAS =IF(TODAY()=M7+K7-O7,Q7,""). IT ALSO LEAD TO QUESTIONS I COULD NOT WORK OUT :-
WOULD AN IF AND TODAY FORMULA RESULT IN THEIR ENTITLEMENT AND/OR BALANCE BEING CONTINUALLY UPDATED ONCE THE DESIRED DATE IS REACHED? i.e. Would Fred Bloggs be given 32 days for the 2021 period on 01/05/2021 and again for every other day passed 01/05/2021?
HOW DO I PREVENT THE ACTION IN COLUMNS K AND Q BEING REPEATED MORE THAN ONCE?
WOULD IT BE POSSIBLE FOR COLUMN Q, ONCE IT HAS BEEN POPULATED, TO ONLY UPDATE FROM THE CHANGES IN COLUMN O

IF and Toady.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1
2	NAME		2020 HOLIDAY		HOLIDAY		HOLIDAYS TAKEN		2020 BALANCE		2021 HOLIDAY		HOLIDAY		HOLIDAYS TAKEN		2021 BALANCE
3			ENTITLEMENT		START DATE		OR BOOKED		REMAINING		ENTITLEMENT		START DATE		OR BOOKED		REMAINING
4
5	FRED BLOGS		32		01/05/2020		35		-3				01/05/2021
6	BILL BATES		27		01/01/2020		11		16				01/01/2021
7	JEN CLOSE		27		01/06/2020		0		27				01/06/2021
8	MONICA FAR		32		01/11/2020		41		-9				01/11/2021
9	SALLY NOWHERE		24		01/05/2020		19		5				01/05/2021
10	IAN TEMPEST		32		01/01/2020		31		1				01/01/2021
11	FOOT BALLER		27		01/06/2020		29		-2				01/06/2021
12	CHAIN SMOKER		32		01/03/2020		33		-1				01/03/2021
13	BEER DRINKER		24		01/09/2020		5		19				01/09/2021
14	ANN OTHER		32		01/02/2020		16		16				01/02/2021
15
Sheet1

Cell Formulas
Range	Formula
I5:I14	I5	=C5-G5
M5:M14	M5	=DATE(YEAR(E5)+1,MONTH(E5),DAY(E5))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I6:I14	Cell Value	>=1	text	NO
I6:I14	Cell Value	<0	text	NO
I5	Cell Value	>=1	text	NO
I5	Cell Value	<0	text	NO

 

[smozgur]

Welcome to the MrExcel Message Board.

This is to inform you that I have updated your post to make it in proper structure as @Fluff explained in the test post you sent.

Please follow these basic rules to make your post more readable next time. It will help to receive quicker responses, and potential answers.

1. Do not write the descriptions and your question in the worksheet to be converted by XL2BB. It will always create the unreadable look with wider columns as you originally pasted, and also tested in the test area.
2. Keep the question title shorter instead of asking questions in the title consists of multiple sentences. Just look at the current title I edited. It is the all info needed in the title.