# Get instant live expert help on I need help with work day or workday

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Hi I need help with a formula I'am trying to calculate a work date 42 days after an episode start date. So the start dates are in Day, Month, year (all drop downs boxes) when I put in the formula- =WORKDAY(w45,42) and the start day is 1/1/2017 the answer comes back with 1/1/1900 !! What am I doing wrong with the year? Thanks for your help Barbara
Solved by B. S. in 27 mins
I have schedule to make. I need a formula that if the date in prev column falls on a weekend or holiday, set the date to the next viable business day. I have the formula for the 2nd half of that condition =WORKDAY(C2,1,D30:D40) but I need the IF part of the condition to the left of the equal sign. (D30:D40 is my list of holidays)
Solved by B. B. in 18 mins
WHY WON'T =SUM(DAY 1:DAY 31!D2) WORK IN EXCEL TO SUM D2 FROM MULTIPLE SHEETS IN MY WORK BOOK
Solved by D. Q. in 21 mins
I need capacity on annual workday basis. Someone already working on the file
Solved by D. Y. in 27 mins
Column to calculate percentage, time users x 8hrs day. My issue is when I have several issue on same day x number of users. Example 100 percent impact 6 users but I have another issue x also 100 impact. My work around could of been I went to new work list where I found 2nd issue. How can I calculate issue each day but not double dipping or how can I explain my work around is I went to new work list
Solved by T. S. in 17 mins