Can you help?
I want to use an IF function to look up a date field and if that date is within the last 2 weeks then the words "2 weeks" appears.
I have tried this but it is not working - can anyone advise...
=IF(CK8>NOW()-(2*7),"2 Weeks","")
Thanks
I want to use an IF function to look up a date field and if that date is within the last 2 weeks then the words "2 weeks" appears.
I have tried this but it is not working - can anyone advise...
=IF(CK8>NOW()-(2*7),"2 Weeks","")
Thanks