I have subcontractors who provide me with certificates of insurance. I need to create a formula that lets me know if the certificate is Current or Expired using todays date and the expiration date of their policy.
In the spreadsheet cell D8 represents the date their policy is set to expire. The formula is close...right now it puts the word Expired where I want it to go....But it doesn't change to Current if the policy is current.
=IF(D8>"TODAY","Current","Expired")
Any suggestions???
Crystal
In the spreadsheet cell D8 represents the date their policy is set to expire. The formula is close...right now it puts the word Expired where I want it to go....But it doesn't change to Current if the policy is current.
=IF(D8>"TODAY","Current","Expired")
Any suggestions???
Crystal