if date falls on weekend, roll to Monday

daveyc18

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

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,013
Office Version
365, 2010
Platform
Windows, Mobile
Last edited:

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,341
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
420
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,341
Not from me. I don't know enough about VBA.
Just format the cell to display the years as 2 digits.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,013
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,089,242
Messages
5,407,108
Members
403,125
Latest member
vbambre

This Week's Hot Topics

Top