if date falls on weekend, roll to Monday

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
388
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,345
Office Version
365, 2010
Platform
Windows, Mobile
Last edited:

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,314
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
388
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,314
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,345
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,516
Messages
5,340,880
Members
399,397
Latest member
VolodimiirSr

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top