Find a list of dates in a changing calendar!

Hi,

For a loan repayment calculator, if the repayment date is a weekend or a public holiday the spreadhseet should say "NGBD" (not good business day) otherwise "GBD" (good business day).

How to I build this functionality knowing that the starting date will be a variable.

Attached is an example, which includes dates of holidays I wish to automaticlaly be listed as NGBD.

Thanks!

Here is one option (see encl. file):

I reduced the file size by deleting some rows and saved it in 2007 format.

Hope this helped
Ola

Hi, thanks for the help that looks good.

Thanks for the feedback
Ola