Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel formula

  • 11-12-2020 11:48am
    #1
    zetor 4911
    Registered Users, Registered Users 2 Posts: 430 ✭✭


    Hi,
    Maybe someone could help me with an excel formula. If I enter say March in cell A1 I want to write a formula in another cell (A2) that will add 1 month to cell A1 so April should be in cell A2 anyone have any solution? Thanks in advance


Comments

  • #2
    kevincaomhin
    Registered Users, Registered Users 2 Posts: 72 ✭✭kevincaomhin


    zetor 4911 wrote: »
    Hi,
    Maybe someone could help me with an excel formula. If I enter say March in cell A1 I want to write a formula in another cell (A2) that will add 1 month to cell A1 so April should be in cell A2 anyone have any solution? Thanks in advance
    The following could work for limited number of rows;

    If you enter a date in cell A1 - 11/12/2020
    Change format of cell to custom "mmmm"
    it should show December
    Go to cell A2 and enter formula =A1 +15
    That should show January
    etc etc.


  • #3
    phonypony
    Registered Users, Registered Users 2 Posts: 1,320 ✭✭✭phonypony


    I would use edate- Use the cell formatting as Kevin says, then in A2: =edate(A1, 1)


  • #4
    [Deleted User]
    Posts: 11,614 ✭✭✭✭ [Deleted User]


    zetor 4911 wrote: »
    Hi,
    Maybe someone could help me with an excel formula. If I enter say March in cell A1 I want to write a formula in another cell (A2) that will add 1 month to cell A1 so April should be in cell A2 anyone have any solution? Thanks in advance

    In A1 type March, in B1 type April. then highlight both cells and drag the fill button at the bottom right hand corner of the selected cell to the right and it will automatically fill in the months.


  • #5
    Jimbob1977
    Registered Users, Registered Users 2 Posts: 2,239 ✭✭✭Jimbob1977


    Automatically (no need for formulae):

    1. Write "Mar" or "Mar-2020" in Cell A1

    2. Drag Cell A1's bottom-right hand corner by the cursor


    It will populate the coming months indefinitely.

    It can be dragged left-to right or up-to-down

    To your heart's content.


  • #6
    Seth Brundle
    Moderators, Politics Moderators Posts: 40,296 Mod ✭✭✭✭Seth Brundle


    If the word "March" is in cell A1 then use the following formula... 
    =TEXT(EDATE(DATEVALUE("01-" & A1 & "-2020"),1),"mmmm")

    DATEVALUE("01-" & A1 & "-2020") allows me to convert the word to an actual date.
    EDATE allows me to add one month to our date
    TEXT allows me to format our new date in mmmm (full month name) format


  • Advertisement
  • #7
    zetor 4911
    Registered Users, Registered Users 2 Posts: 430 ✭✭zetor 4911


    kevincaomhin wrote: »
    The following could work for limited number of rows;

    If you enter a date in cell A1 - 11/12/2020
    Change format of cell to custom "mmmm"
    it should show December
    Go to cell A2 and enter formula =A1 +15
    That should show January
    etc etc.

    Thanks for that. I prefer to not enter the date in cell A1 just want to enter the month (March) is this possible?


  • #8
    zetor 4911
    Registered Users, Registered Users 2 Posts: 430 ✭✭zetor 4911


    Seth Brundle wrote: »
    If the word "March" is in cell A1 then use the following formula... 
    =TEXT(EDATE(DATEVALUE("01-" & A1 & "-2020"),1),"mmmm")

    DATEVALUE("01-" & A1 & "-2020") allows me to convert the word to an actual date.
    EDATE allows me to add one month to our date
    TEXT allows me to format our new date in mmmm (full month name) format

    That worked for me many thanks to all for the suggestions.


Advertisement