Hi,

I have a requirement to write a formula to determine and flag the date to YES or NO if the date falls in the next 5 days and I wrote my code as below but I am not able to correctly compile the formula. Please give suggestions ..

‘=IF((N2-TODAY())<5;"Yes";"No")’

Where N2 is the column which has the date field.

Regards

GP Kumar