This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have documents in start date until end date, so I plan to make it easy viewed, what formula to be used or can you give sample ways?
if my document still Valid, must be valid shown, if my documents expired, must be shown expired. thank you, sirs, or mam
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Adjust the cell references accordingly but with start date in A1 & end date in B1
=IF(AND(TODAY()>=A1,TODAY()<=B1),"Valid","Expired")
Adjust the cell references accordingly but with start date in A1 & end date in B1
=IF(AND(TODAY()>=A1,TODAY()<=B1),"Valid","Expired")
THANK YOU, SIR MR. RonaldoOneNil, MOST HELPFUL TO ME, now I can more enjoying my office 365 Home. Happy Am I, sir. Now I can say is simple. I wonder they have "AND". But never mind. Again Thank You so Much.