Forum Discussion
Formating automatic display of expired, open or closed
Hello, Thank you for let me be part of this community. My issue is excel related. I do not kn w at all how to resolve or to figure out my doubt.I am learning english and if you see any mistake plea...
Hi sir,
I have an issue in my office work. I need formula for excel sheet. I have an excel sheet containing electrical License data. tabel containing the following label
| S.no | Name of Firm & Address | License No. | Category | Valid upto | Active/Non active/Cancelled |
| 1 | abc | 1520 | E | 29-08-2022 | show active/Non active/ cancelled |
Note: one month grace period also allowed to contractor, after the end of one month grace period, license will be non active. and after two years license will be cancelled.
Kindly sir put up formula to automatically show active/non active/cancelled thanks