If/Then Formula Using Dates

B

BAUS

Joined
Dec 3, 2011
Messages
2
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 5
Excel Formula - Count Dates from another Sheet 8
Percentage of Cells completed 3
Using Dates with the IF function 2
Conditional Formatting - dates 6
Formula using DATES 4
Emailing formula results 1
HELP with a formula 7

Top