HI!

Thanks for all the help in the very recent past!

I have a new item that I would like to do...

In cell "E6" I would like to return either 1 or 16 based on the result of a
lookup table in cell "DB4". The easiest would be if the answer was even
then "16" would be returned. If it was odd then "1". I know that there is
an easy solution but can't get me head around it...

What I'm trying to do is to change the dates on a payroll sheet... this
seems like the easiest way to do so... however if somebody could tell me a
way to populate the columns to the right of the first day of the pay period
("E6") based on a period picked from a control that would be even better!

Then I think that there's a way to mark and identify Holidays correct? In
the perfect world... the user would pick a pay period... the cells "E6" to
"T6" would fill in the dates and if there was a holiday during that period
that the column would be highlighted... could that be done?

Thanks in advance for looking at my posts! The current project looks very
amazing thanks to you!

Greg