Difference between dates

[jenny2010]

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.

 

[Pete_UK]

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

 

[Sean Timmons]

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]

sorry i ment down the column...

 

[Sean Timmons]

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

 

[jenny2010]

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

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]

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

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

 

[Fred Smith]

Check the format of your cell. If it's a date, change it to a number. If
not, try widening the column.

Regards,
Fred.

 

[jenny2010]

Nice!! Thanks a bunch!

Check the format of your cell. If it's a date, change it to a number. If
not, try widening the column.

Regards,
Fred.

 

[Sean Timmons]

Looks like Fred go to you first.

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