Results 1 to 7 of 7

Thread: $$$$ Help w/ an Addition Formula! $$$$

  1. #1
    Seeker mk_alii's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    Excel 2013

    Question $$$$ Help w/ an Addition Formula! $$$$



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Excel Guru Members!
    I am a new member to the forums, looking for some help

    I have a month addition question. I'll try to explain this with screenshots as best I can

    So, on page 1, I have a date on Cell F1: 07/01/2017
    On page 2 I'd like that date mirrored, so I just did a simple ='Page1'!F1 formula to mirror page 1's date. That way, when I change the page 1 date, page 2 will mirror this
    On page 3, I'd like that same mirroring effect to happen, but I'd like page 3 to instead, mirror the month on page 1 and add 6 months to it. So the formula ='Overall Performance'!F1 does not work here because it does not add 6 months to the date. I tried doing a +6 before and after and it did not work lol.

    How do I do fix this?

    Thanks in Advance!

    P.S. I also have a few other more complicated questions, I'd be willing to make it worth your while if you can help me out personally

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    254
    Articles
    0
    Excel Version
    2007
    .
    The formula for Sheet3 ( if your original date is located on Sheet1, A1 ) would be : =EDATE(Sheet1!A1,6)

  3. #3
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,711
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Quote Originally Posted by mk_alii View Post
    P.S. I also have a few other more complicated questions, I'd be willing to make it worth your while if you can help me out personally
    Hi and welcome
    if you have other questions, we recommend you start a new thread for each question ( with an eventual link to any other relevant posts).

    Also be aware that solving or asking questions via PM is not allowed on the forum

    Thx
    Thank you Ken for this secure forum.

  4. #4
    Seeker mk_alii's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    Excel 2013
    This worked!

    Thank you so much buddy!

  5. #5
    Seeker mk_alii's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Pecoflyer View Post
    Hi and welcome
    if you have other questions, we recommend you start a new thread for each question ( with an eventual link to any other relevant posts).

    Also be aware that solving or asking questions via PM is not allowed on the forum

    Thx

    Thank you friend! Will do!

  6. #6
    Seeker mk_alii's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Logit View Post
    .
    The formula for Sheet3 ( if your original date is located on Sheet1, A1 ) would be : =EDATE(Sheet1!A1,6)
    This worked! Thank you buddy!

  7. #7
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    254
    Articles
    0
    Excel Version
    2007
    You are welcome.

Tags for this Thread

Posting Permissions

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