+ Reply to Thread
Results 1 to 6 of 6

add 1 month

  1. 09-14-2022, 03:02 AM #1
    adamasmay
    adamasmay is offline
    Forum Contributor
    Join Date
    03-08-2021
    Location
    thailand
    MS-Off Ver
    2016
    Posts
    117

    add 1 month

    I have value a= 202212 (yyyyMM)
    I want +1 month to 202301

    Please guide me about it.(VBA,Macro)
    Reply With QuoteRegister To Reply
  2. 09-14-2022, 03:06 AM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,573

    Re: add 1 month

    adamasmay,

    Many of your thread left no reply from you.

    Do your country have any appreciation word? or is this only you?
    Reply With QuoteRegister To Reply
  3. 09-14-2022, 03:10 AM #3
    adamasmay
    adamasmay is offline
    Forum Contributor
    Join Date
    03-08-2021
    Location
    thailand
    MS-Off Ver
    2016
    Posts
    117

    Re: add 1 month

    I add reputation for thank you.
    Reply With QuoteRegister To Reply
  4. 09-14-2022, 05:30 AM #4
    adamasmay
    adamasmay is offline
    Forum Contributor
    Join Date
    03-08-2021
    Location
    thailand
    MS-Off Ver
    2016
    Posts
    117

    Re: add 1 month

    Anyone can help me for solve it.
    Thank you.
    Reply With QuoteRegister To Reply
  5. 09-14-2022, 06:00 AM #5
    pjwhitfield
    pjwhitfield is offline
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: add 1 month

    try:
    Please Login or Register  to view this content.
    assuming your value is in A1
    If someone has helped you then please add to their Reputation
    Reply With QuoteRegister To Reply
  6. 09-15-2022, 08:08 AM #6
    ByteMarks
    ByteMarks is offline
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,032

    Re: add 1 month 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Month-Over-Month Change When Missing Value for Month
    By JGroeger in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-23-2022, 10:45 AM
  2. if month & year = current month, return 1, otherwise 1 + percentage from one month back
    By losincog in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2020, 04:02 PM
  3. [SOLVED] Return Month-on-Month growth using current month-prior month/prior month per country
    By losincog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2020, 05:37 AM
  4. [SOLVED] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  5. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  6. [SOLVED] Counting & summing formula (until last month,this month,until this month..
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2014, 01:14 PM
  7. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1