View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jenny2010 jenny2010 is offline
external usenet poster
 
Posts: 5
Default Difference between dates

it didn't work i got ... ####

"Sean Timmons" wrote:

Assuming you have added the analysis toolpak...

=NETWORKDAYS(A1,TODAY())

Presuming you want to compare A2 to today, just drag the formula across the
row.

Placing a $ in front of the 1 would cause this NOT to calculate across the
row.

"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.