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
Bookmarks