ExcelBanter - How can I reference an Outlook calendar holiday from Excel?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I reference an Outlook calendar holiday from Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/63360-how-can-i-reference-outlook-calendar-holiday-excel.html)

Garhart

How can I reference an Outlook calendar holiday from Excel?

I'm using Excel 2003 and Windows XP Prof.

From Excel I want to reference the current year holidays by name (ie.
Memorial day, Independence, Christmas etc..) and return the date (ie.
12/25/2006) to Excel.

Can anyone give me an example of how this can be done?

TIA

All times are GMT +1. The time now is 10:34 AM.