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