WebNov 15, 2024 · Sorted by: 2. This function should do what you want: Function GetNextWorkingDay (dt As Date) As Date Select Case Weekday (dt) Case 1 GetNextWorkingDay = DateAdd ("d", 1, dt) Case 7 GetNextWorkingDay = DateAdd ("d", 2, dt) Case Else GetNextWorkingDay = dt End Select End Function. Share. Improve this answer. … WebIn the Formula bar, place your cursor inside the (), click value, and then type C2-B2. Inside the (), click format_text, and then type "h:mm", including the quotation marks, to format the …

3 Ways to Subtract in Excel - wikiHow

WebAug 31, 2010 · Need to subtract a date/time from another date/time and exclude weekends if necessary: Start 8/27/2010 8:30:00 am. End 8/31/2010 14:03:00 pm. Answer should be 53:33 total hours or can be in days 2.2. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. WebTo add or subtract workdays days to a date, respecting holidays but assuming a 7-day workweek, you can you can use the WORKDAY.INTL function. In the example, the formula … saints row 1 phone numbers

How to add and subtract dates in Excel - Ablebits.com

WebMay 4, 2014 · We do not work weekends, however we receive some calls on weekends that would need to be calculated based on the first business day after the weekend (usually Monday). I have tried using the following formula except when the call comes in on the weekend. =(NETWORKDAYS(A2,b2)-1+MOD(b2,1)-MOD(A2,1))*24. I use Excel 2007 at … WebTo add days to a date while excluding specific days (i.e. exclude Tuesdays and Thursdays, Wednesdays only, etc.) you can use the WORKDAY.INTL function with a special pattern code. In the example shown, the formula in C7 is: =WORKDAY.INTL(B7,7,"0101000") This formula adds 7 days to the date in B7, excluding Tuesdays and Thursdays. WebMethod #1: Use the NETWORKDAYS Function to Exclude Saturdays and Sundays Method #2: Use the NETWORKDAYS Function to Exclude Saturdays, Sundays, and Holidays … thin film engineer jobs