A calculated field has been created within my Sharepoint library to show what items will be due for review within 21days of the current date. I understand the [Today] [Now] don't work too well within Sharepoint, and wondering if anyone can provide assistance. Current formula is
=IF( AND( [Expiry Date]-NOW()>=0 , [Expiry Date]-NOW()<=21 ) ,"Expiring Soon" ,"Effective" )
The return of the information is correct, but as the title advises, it doesn't refresh unless I go into the formula, copy and paste it back in and Save.