Hi, Is there a way to retrieve the SSL Certificate Validity details from a website and dynamically saving to specific cell. For example:
B2.Value = google.com the on retrieve the details C2.Value (Not Before Mon, 13 Sep 2021 04:07:13 GMT / Not After Sat, 20 Nov 2021 04:07:12 GMT)
and if the Not After date is in the future meaning the SSL ceritificate has not expired then B2.Color = Green else Red to indicate it has expired.
Would be nice if Cell D2 would then provide countdown to expiration in Days 00:00:00.
Thank you!!
B2.Value = google.com the on retrieve the details C2.Value (Not Before Mon, 13 Sep 2021 04:07:13 GMT / Not After Sat, 20 Nov 2021 04:07:12 GMT)
and if the Not After date is in the future meaning the SSL ceritificate has not expired then B2.Color = Green else Red to indicate it has expired.
Would be nice if Cell D2 would then provide countdown to expiration in Days 00:00:00.
Thank you!!