ExcelBanter - auto highlighting x#of days prior to & after any given date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - auto highlighting x#of days prior to & after any given date (https://www.excelbanter.com/excel-worksheet-functions/255867-auto-highlighting-x-days-prior-after-any-given-date.html)

Moovysheek

auto highlighting x#of days prior to & after any given date

I have a 2010 calendar on 1 8.5x11 pg. i want to be able to click on any
given day and have the 15 days prior to & 30 days after automatically
highlight. How do I do this?

All times are GMT +1. The time now is 09:53 PM.