Counting out 10 days from today and then adjusting to the following business day

		Microsoft Office Forums > Microsoft Excel > Excel
Counting out 10 days from today and then adjusting to the following business day

05-19-2018, 08:47 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

USE WEEKDAY() with ISO weekday numbers. Then you can use formula (on fly)

Code:

=E6 + (8 - WEEKDAY(E6,2))*(WEEKDAY(E6,2) > 5)

Last edited by ArviLaanemets; 05-19-2018 at 04:48 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fifteen Days From Today's Date, (Not Counting Saturday & Sunday).	StephenRay	Word VBA	13	07-26-2017 11:22 AM
Sum Function over Today +/- 60 Days	gabeha	Excel	2	09-12-2014 01:13 AM
Using Outlook Today Calendar Days	cwksr	Outlook	0	08-13-2014 10:57 AM
Conditional formatting of Today +21 days?	SHERMAN	Excel	3	12-20-2010 08:08 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:51 AM.