How to Put the Date Between Quotes??

Date between double quotes:

1. Right click

2. Format cells

3. Custom

4. Type this custom Format: \"dd-mmm-yyyy\"

5. Ok

How to Check for The Expiry Date, and Highlight It

 Date Transactions & Conditional Format using IF

As explained above.. please not the following points:

1) Expiry date calculated as Issuance date (-) 12 months.
(we adjust it by the function EOMONTH() end-of-month)
2) Days left to expiry = the expiry date (-) today
3) Status of the license, showing if it is expired or still running, using simple IF() function
(we used conditional formatting here to change its color to yellow when expired)
4) Action needed, using VLookup() function

How to Calculate Age?? The most simple method..

 A simple example of date calculation (age). we calculate 3 separate cells (for years, months, and days) using DATEDIF() function, then we grouped them it into one sentence as shown using "&"