Hi there
I have the following formula that I usually use in my sheet.
=IF(W3<TODAY()-14;"expired";"approved")
Unfortunately, I have to go back to the 28-12-2008 to recreate the data. Am I able to put in the 28-12-2008 instead of TODAY? I could not figure it out.
Thank you for your help
Roman
I have the following formula that I usually use in my sheet.
=IF(W3<TODAY()-14;"expired";"approved")
Unfortunately, I have to go back to the 28-12-2008 to recreate the data. Am I able to put in the 28-12-2008 instead of TODAY? I could not figure it out.
Thank you for your help
Roman