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...
weknowsafety491519 , I can't download your file. For such sample
formula could be
=IF(C2>1,"Closed",IF(TODAY()>B2,"Expired","Open"))
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
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
