Difference between dates
 

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.

Difference between dates
 

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.

Difference between dates
 

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.

Difference between dates
 

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.

Difference between dates
 

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.

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.

Difference between dates
 

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.

Difference between dates
 

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" wrote in message
...
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.

Difference between dates
 

Nice!! Thanks a bunch!

"Fred Smith" wrote:

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" wrote in message
...
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.

Difference between dates
 

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.