eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).
D daveyc18 Active Member Joined Feb 11, 2013 Messages 387 Oct 15, 2019 #1 eg if the maturity date was october 13, i'd want the maturity date to now be october 14 (monday).
steve the fish Well-known Member Joined Oct 20, 2009 Messages 7,727 Office Version 365 Platform Windows Oct 15, 2019 #2 Try this: =WORKDAY(A1-1,1)
D daveyc18 Active Member Joined Feb 11, 2013 Messages 387 Oct 16, 2019 #3 steve the fish said: Try this: =WORKDAY(A1-1,1) Click to expand... for a date of 7/29/33, i'm getting 7/31/33, however 7/29 is a friday, not saturday or sunday. please advise.
steve the fish said: Try this: =WORKDAY(A1-1,1) Click to expand... for a date of 7/29/33, i'm getting 7/31/33, however 7/29 is a friday, not saturday or sunday. please advise.
MARK858 Well-known Member Joined Nov 12, 2010 Messages 11,330 Office Version 365, 2010 Platform Windows, Mobile Oct 16, 2019 #4 daveyc18 said: for a date of 7/29/33, i'm getting 7/31/33, however 7/29 is a friday, not saturday or sunday. please advise. Click to expand... If you put the year as just 33 then the default in Excel/Windows will treat it as 1933 not 2033. The 29th July in 1933 was a Saturday. See the link below https://support.office.com/en-us/article/change-the-date-system-format-or-two-digit-year-interpretation-aaa2159b-4ae8-4651-8bce-d4707bc9fb9f Last edited: Oct 16, 2019
daveyc18 said: for a date of 7/29/33, i'm getting 7/31/33, however 7/29 is a friday, not saturday or sunday. please advise. Click to expand... If you put the year as just 33 then the default in Excel/Windows will treat it as 1933 not 2033. The 29th July in 1933 was a Saturday. See the link below https://support.office.com/en-us/article/change-the-date-system-format-or-two-digit-year-interpretation-aaa2159b-4ae8-4651-8bce-d4707bc9fb9f
S Special-K99 Well-known Member Joined Nov 7, 2006 Messages 8,312 Oct 16, 2019 #5 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.
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.
D daveyc18 Active Member Joined Feb 11, 2013 Messages 387 Oct 16, 2019 #7 Special-K99 said: 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. Click to expand... 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 said: 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. Click to expand... 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.
S Special-K99 Well-known Member Joined Nov 7, 2006 Messages 8,312 Oct 17, 2019 #8 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,330 Office Version 365, 2010 Platform Windows, Mobile Oct 17, 2019 #9 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
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
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am...
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet...
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the...
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...
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...