Retrieve SSL Certificate Validity details

rbahena

New Member
Joined
May 13, 2021
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
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!!
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top