Give Date or Week from Start Date & Desired Weeks

[mycon73]

Hi,

Having a Brain Fart....



Want to get desired date or workweek from given start date & desired weeks


See attached....

[protonLeah]

1. Since WORKDAY() excludes weekends, given 10 weeks, therefore 50 workdays...
E15:

Please Login or Register  to view this content.

2. How is "workweeks" different from week of the year (i.e. WEEKNUM())? You have to have starting point which you didn't give.

[mycon73]

Hi protonLeah

Just about to reply with same function!!!

Momentary brain fart fixed....

Thanks

[alansidman]

Two solutions. Here is a formula based solution

E17 =E9+(E15*7)
E18 =WEEKNUM(E17)

VBA solution:

Please Login or Register  to view this content.

EDIT: Ben types faster than me, I guess.