NetWorkDays to Calendar Days?

E

ectoid

Board Regular
Joined
Jan 18, 2005
Messages
97
Hey there...
If I've got a user specified number of work days (i.e. 10 work days) then how do I convert that to calendar days in a Start and End Date calculation?
For exampl, I know the start day is today and I know it will take 10 working days to complete, how do I calculate the calendar End date?

EndDt = StDt + ?

? = 10days + weekends = 12days to show on calendar
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
Thanks for the reply...when you recommend Workday formula, is that the same as the NetWorkDays formula? The user defined number of days I start with IS the Networkdays, so I'm actually trying to find the converse of the Networkdays formula. I want to undue the number of workdays into its calendar equivlent.

Does that make sense or am I understanding your response incorrectly?

Thanks,
-E
 
Upvote 0
WORKDAY will add the numbers of days (your 10), but exclude weekends.

E.G:

=WORKDAY("01/01/08",10)

will return 15/01/08

there is a third argument available so that you can exclude holidays...
 
Upvote 0
Ah...thanks for the clarification.
My bad...I looked for Workday in the VBA help rather than Excel help on accident and it was unknown...

That's what I needed...thanks again.
-E
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.
Replies
7
Views
199
Alex Blakenburg
A
J
  • Question
How to allocate project hours between specific dates using specific daily hour burn rates and including awkward calendar month start/end+holidays
2
Replies
11
Views
931
felixstraube
F
A
  • Solved
NETWORKDAYS vs COUNTIFS
Replies
2
Views
151
amberd
A
Z
  • Question
Dynamic Working and Week days remaining until end of month from a specific date in the month
Replies
3
Views
126
Peter_SSs
Peter_SSs
A
  • Question
Creating a Calendar for a Month with tasks
Replies
0
Views
107
anuradhagrewal
A

Forum statistics

Threads
1,214,643
Messages
6,120,707
Members
448,981
Latest member
recon11bucks

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top