Adding weekdays in a date formula
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...
|