+ Reply to Thread
Results 1 to 12 of 12

Calculating 2 months and 10 days from a specific date

  1. #1
    Registered User
    Join Date
    09-07-2013
    Location
    glasgow
    MS-Off Ver
    Excel 2007
    Posts
    4

    Calculating 2 months and 10 days from a specific date

    eg

    Cell E2= 07/09/13, how could i get it to display in red "call now" in cell F2 2months and 10 days later

    Any help appreciated

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Calculating 2 months and 10 days from a specific date

    Try this regular formula:
    =EDATE(E2;2)+10

    Does that work for you?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,527

    Re: Calculating 2 months and 10 days from a specific date

    F2 = eomonth(a16;2)+10
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Calculating 2 months and 10 days from a specific date

    Hi, try
    =IF(DATE(YEAR(E2),MONTH(E2)+2,DAY(E2)+10)<=TODAY(),"call now","")

    To get it to display the text in red, you could just format the cells to red text, since they are either blank or should be red? Or you could use conditional formatting.

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Calculating 2 months and 10 days from a specific date

    formula in f2
    =IF(TODAY()>=EDATE(E2,2)+10,"CALL NOW","")
    conditional format cell as
    cell value equal to
    ="call now" choose red font
    Last edited by martindwilson; 09-07-2013 at 10:38 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  6. #6
    Registered User
    Join Date
    09-07-2013
    Location
    glasgow
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Calculating 2 months and 10 days from a specific date

    just get an error with formula msg

  7. #7
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Calculating 2 months and 10 days from a specific date

    Hi, my previous suggestion was a bit clumsy :-)
    With Ron's solution:

    =IF(EDATE(E2,2)+10<=TODAY(),"call now","")

  8. #8
    Registered User
    Join Date
    09-07-2013
    Location
    glasgow
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Calculating 2 months and 10 days from a specific date

    Martin Wilson

    This gets the dates correct but only displays a red box with no text, close though

  9. #9
    Registered User
    Join Date
    09-07-2013
    Location
    glasgow
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Calculating 2 months and 10 days from a specific date

    No, afraid this doesn't work

    Quote Originally Posted by estige View Post
    Hi, my previous suggestion was a bit clumsy :-)
    With Ron's solution:

    =IF(EDATE(E2,2)+10<=TODAY(),"call now","")

  10. #10
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Calculating 2 months and 10 days from a specific date

    well you must be doing something wrong! see attached
    Attached Files Attached Files

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,527

    Re: Calculating 2 months and 10 days from a specific date

    @pedkerr.

    You get several answers from several members, in that case you can better add to whom your replying.

    Please post you example, with the given solutions, which don't work.

  12. #12
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Calculating 2 months and 10 days from a specific date

    well id have thought its obvious as only 2 people have referred to using cf to get the red "call now" as i the op original question

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating years/months/days between two dates
    By jen9537 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-05-2014, 03:03 AM
  2. calculating the experience in number of years, months, days.
    By marineharish in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-22-2013, 12:47 PM
  3. Replies: 2
    Last Post: 12-09-2009, 10:44 AM
  4. problem of calculating years months and days
    By naughtyboy in forum Excel General
    Replies: 1
    Last Post: 08-07-2006, 06:25 AM
  5. Replies: 3
    Last Post: 06-28-2006, 05:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1