Hello,
make sure you have the Analysis ToolPak enabled.
Then manually enter the first date into A2
In A3 enter
=WORKDAY(L2,1)
format as date and copy down.
Hello,
make sure you have the Analysis ToolPak enabled.
Then manually enter the first date into A2
In A3 enter
=WORKDAY(L2,1)
format as date and copy down.
WORKDAY has obvious advantages in so far as it is easy to handle public holidays should you need to - if you don't you could equally use standard:
A3: =A2+LOOKUP(WEEKDAY(A2,2),{0,5},{1,3})
copied down
(you can still account for public holidays without resorting to ATP but ATP makes life a whole lot easier)
note: small typo in Teylyn's prior post - reference in WORKDAY is meant to be A2
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks