if date falls on weekend, roll to Monday

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
387
eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).
 

MARK858

Well-known Member
Joined
Nov 12, 2010
Messages
11,338
Office Version
365, 2010
Platform
Windows, Mobile
Last edited:

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,312
7/29/33 is being translated as 1933 not 2033.

7/29/1933 was a Saturday hence the rollover to Monday.
If you want 7/29/2033 you'll need to enter the date as 4 digits.
 

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
387
7/29/33 is being translated as 1933 not 2033.

7/29/1933 was a Saturday hence the rollover to Monday.
If you want 7/29/2033 you'll need to enter the date as 4 digits.
is there a macro that will do this for me? actually, ideally, i want to keep the year number displayed as two digits even after the conversion.
 

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,312
Not from me. I don't know enough about VBA.
Just format the cell to display the years as 2 digits.
 

MARK858

Well-known Member
Joined
Nov 12, 2010
Messages
11,338
Office Version
365, 2010
Platform
Windows, Mobile
See Ricks response to the OP's duplicate (well strictly speaking this was the duplicate as they posted the other thread before post number 7) here

but the correct answer is still to enter the dates correctly i.e. 4 figures for the year and then format the cell ;)
 

Forum statistics

Threads
1,078,352
Messages
5,339,712
Members
399,320
Latest member
sut3k

Some videos you may like

This Week's Hot Topics

Top