Give Date or Week from Start Date & Desired Weeks

Hi,

Having a Brain Fart....



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


See attached....

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.

Hi protonLeah

Just about to reply with same function!!!

Momentary brain fart fixed....

Thanks

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.