Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-19-2018, 07:44 AM
crishar crishar is offline Counting out 10 days from today and then adjusting to the following business day Windows 7 64bit Counting out 10 days from today and then adjusting to the following business day Office 2007
Novice
Counting out 10 days from today and then adjusting to the following business day
 
Join Date: May 2018
Posts: 1
crishar is on a distinguished road
Default Counting out 10 days from today and then adjusting to the following business day

I have a current formula that counts out 10 calendar days from an entered date. if the calculated date lands on a weekend or holiday, it currently displays the previous business day (usually a Friday). I would like it instead to display the following business day (usually a Monday).

I'm not sure which part of the formula to adjust to make that change. I've attached a snippet of the current formula. Any help would be greatly appreciated.


Thanks!
Attached Images
File Type: png Formula snip.PNG (15.8 KB, 21 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting out 10 days from today and then adjusting to the following business day 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 06:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft