if date falls on weekend, roll to Monday

daveyc18

Well-known Member
Joined
Feb 11, 2013
Messages
741
Office Version
  1. 365
  2. 2010
eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Last edited:
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
Not from me. I don't know enough about VBA.
Just format the cell to display the years as 2 digits.
 
Upvote 0
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 ;)
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top