Looks like Fred go to you first. :-)

"jenny2010" wrote:

the formula didn't work it came up ####

"Sean Timmons" wrote:

Use same formula as above, but drag down instead of across...

"jenny2010" wrote:

sorry i ment down the column...

"jenny2010" wrote:

I need to calculate the difference between a date and todays date in
Workdays...

Also i would like to know how to i can have the same formula continue
through the whole row but instead of the difference between A1 and today
continue A2, A3, A4.... etc.