I am trying to subtract 3 days from the current system date. from the below syntax,
Can anyone advice how to solve this and may I know can I use that syntax in the
“=IF(ISNA(VLOOKUP(A2,‘18-01-19’!A:D,1,FALSE)),”“New Deal”","“Old Deal”")"
Instead of hardcoding date in the vlookup formula can I use dynamic value ?
Thank you very much in advance