| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference of two dates | Excel Discussion (Misc queries) | |||
| difference between dates | Excel Discussion (Misc queries) | |||
| difference between dates | Excel Discussion (Misc queries) | |||
| difference between dates | Excel Discussion (Misc queries) | |||
| difference between two dates | Excel Discussion (Misc queries) | |||
Linear Mode
