Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 07-21-2017, 11:03 AM
StephenRay StephenRay is offline Fifteen Days From Today's Date, (Not Counting Saturday & Sunday). Windows 7 64bit Fifteen Days From Today's Date, (Not Counting Saturday & Sunday). Office 2010 64bit
Advanced Beginner
Fifteen Days From Today's Date, (Not Counting Saturday & Sunday).
 
Join Date: Jan 2012
Location: Overland Park, Kansas
Posts: 53
StephenRay is on a distinguished road
Default

Gmayor,
I added to your code to highlight and copy the date.
It also displays a message in the Status Bar.
Here it is:
Sub Macro2()
'
'Sub Macro1()
Dim strBothItems As String
Dim firstPart As String
Dim datePart As String
firstPart = "Fifteen Days from Today "
datePart = Format(DateDue(Date, 15), "mm-dd-yyyy")
strBothItems = firstPart & datePart
Selection.TypeText Format(DateDue(Date, 15), "mm-dd-yyyy")
Selection.HomeKey Unit:=wdLine, Extend:=wdExtend
Selection.Copy
Application.StatusBar = strBothItems
‘Application.StatusBar = Format(DateDue(Date, 15), "mm-dd-yyyy")
'Application.StatusBar = "Fifteen Days from Today "
End Sub

Public Function DateDue(ByVal vDate As Date, ByVal iDays As Variant) As Variant
'Graham Mayor - http://www.gmayor.com - Last updated - 14 May 2017
'Add weekdays to date - from Monday if date falls at weekend
Dim iCount As Integer

DateDue = Null
If IsNull(vDate) Or IsNull(iDays) Then
GoTo lbl_Exit
End If

Select Case Weekday(vDate)
Case Is = 1 ' Sunday
vDate = DateAdd("d", 1, vDate)
iCount = 0
Case Is = 7 ' Saturday
vDate = DateAdd("d", 2, vDate)
iCount = 0
Case Else
iCount = Weekday(vDate) - 2
End Select

iDays = iDays + iCount
vDate = DateAdd("d", iCount * -1, vDate)
DateDue = DateAdd("d", iDays Mod 5, DateAdd("ww", Int(iDays / 5), vDate))
lbl_Exit:
Exit Function
End Function
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Fifteen Days From Today's Date, (Not Counting Saturday & Sunday). Counting the difference in days within multiple groups wheddingsjr Excel 2 03-28-2017 07:38 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 11:24 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