I am trying to make a template for our staff that will easily calculate 50
school days from a given date. This is a state compliance issue for special
education, I
need to be able to have the secretaries calculate this date for student
evals.

I have formatted the sheet for dates. In A1 I type in the date I want to
figure 50 days from, in column B I have typed in ALL school days off.

In A2 I use the formula =WORKDAY(TODAY(),50,B:B and will get the same date
no matter what date I enter into A1, ie if I enter in 1/1/2010, the return
date for 50 days will be 4/26/2010, if I type in 2/12/2010 I get 4/26/2010.
Obviously I am doing something wrong.....

The ultimate goal is a template for all surrounding districts that the
secretaries can easily use to calculate the 50 days - any help showing me
what I am doing wrong will be greatly appreciated.

Thanks!