Forum Discussion

weknowsafety491519's avatar
weknowsafety491519
Copper Contributor
Mar 25, 2019

Dear SergeiBaklan 

Thank you very much for your help on this matter. Youhave been VERY USEFUL AND KIND helping me with this issue. Sorry that my file did not open. I used the formula and works PERFECTLY. 

thanks once again,

Bless you and have a great week.

Juan

    • Ziad_Khan's avatar
      Ziad_Khan
      Copper Contributor
      Aug 29, 2022

      SergeiBaklan 

       

      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.noName of Firm & AddressLicense No.CategoryValid uptoActive/Non active/Cancelled
      1abc1520E29-08-2022show 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 

Resources