My shul has asked me to compile an annual list of all days when "El Maleh" (prayer said for yahrtzeit) is omitted.
People in my shul know that it is said any day the Torah is read, meaning Mon., Thurs, and Shabbat mincha. Generally, El Maleh would be omitted on a day Tachanun is not said, or in the case of Shabbat mincha, it would include if Tachanun is omitted on the following day (e.g. Erev Rosh Hodesh.)
I need the lsit to include both the Hebrew and English date and the reason it is omitted (e.g. - Rosh Hodesh, Chanukah, during Nissan, etc.)
For the past few years, I created an Excel sheet and did this manually. I'd like to keep this in an easy to read list / column format such as Excel rather than in a calendar program such as Outlook.
I think Hebcal or MyZmanim can produce a list like this, but I'm not sure. I need something that, ideally, I can import into Excel, even if this involves some export / import / converting from a text format, etc.
Can someone recommend a program / method available that can do this?