I have a excel spreadsheet where we keep audit dates for when equipment is
checked/audited. I have a column with the date it was audited on. Now, the
equipment need auditing again in 6mths time. Is there a way of getting excel
to let me know that date?

I also have certificates that expire after say, 3 years (for first aid) is
there a way of excel flagging up when it has expired from the date the
certificate was issued?

Thankyou