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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,076
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,076
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 ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,089,850
Messages
5,410,770
Members
403,329
Latest member
IR84

This Week's Hot Topics

Top