Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Try this formatted as a date =WORKDAY(A1,80) If you get a #NAME error then Tools|Addins and check the analysis toolpak. the formula can also take a third argument =WORKDAY(A1,80,B1:B10) Where B1:B10 contaions a list of dates (Holidays) you would also like to exclude. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Handy" wrote: How would you add weekdays to a formula? ex. A1 = 1/1/10 If I want to add 80 WORKDAYS (excluding weekends), what formular would I use? =(A1+80) does't work... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display yesterday's date but only for weekdays? | Excel Worksheet Functions | |||
Would like to add 20 working/weekdays to a date | Excel Discussion (Misc queries) | |||
Date, Weekdays | Excel Discussion (Misc queries) | |||
Subtracting weekdays from a date: | Excel Worksheet Functions | |||
Date exclude weekdays | New Users to Excel |