Sysadmin

This is an automated archive.

The original was posted on /r/sysadmin by /u/danj2k on 2024-01-22 10:28:14+00:00.

At the moment we use an Excel spreadsheet to keep track of when our servers were last updated.

I'd like to add some conditional formatting to this to make it visually easier to spot servers that are out of date and need the latest updates installing.

At the moment I've got a simple "30 days" formula, but this doesn't take account of situations when the server was updated within the current month but before Patch Tuesday.

Does anyone have formulas that can be used with Excel conditional formatting that account for Patch Tuesday correctly?