Bopo2
11-02-2009, 02:18 PM
Hi All
Well I have a simple spreadsheet calendar (see print screen below) and thanks to the suggestions from the members of the form, I have now used conditional formatting to highlight weekends in a different color for example (print screens outdated)
Anyway, I was wondering if someone knows a formula for working out the bank holidays of a year? I've researched quite a bit on this and I haven't really found anything. Here's the spreadsheet which xlt did which uses conditional formatting to not only find weekends, but current date etc, so if you want to have a play around feel free, as I'm not really getting any closer :doh:.
http://www.vbaexpress.com/forum/showpost.php?p=197979&postcount=3
Well I have a simple spreadsheet calendar (see print screen below) and thanks to the suggestions from the members of the form, I have now used conditional formatting to highlight weekends in a different color for example (print screens outdated)
Anyway, I was wondering if someone knows a formula for working out the bank holidays of a year? I've researched quite a bit on this and I haven't really found anything. Here's the spreadsheet which xlt did which uses conditional formatting to not only find weekends, but current date etc, so if you want to have a play around feel free, as I'm not really getting any closer :doh:.
http://www.vbaexpress.com/forum/showpost.php?p=197979&postcount=3