Have a look at the NETWORKDAYS function in XL Help - it does exactly
what you want, and can also take account of holidays if these are
listed somewhere.

Ensure you have the ATP add-in installed if you are not using XL 2007.

Hope this helps.

Pete

On Aug 13, 4:57*pm, 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.