+ Reply to Thread
Results 1 to 6 of 6

Add EDATE function into an IF function

  1. #1
    Registered User
    Join Date
    11-02-2018
    Location
    UK
    MS-Off Ver
    1809
    Posts
    5

    Question Add EDATE function into an IF function

    Hi folks!

    I am trying to make a cell appear as blank if another cell contains no data;

    In cell K2 I will manually be entering dates
    In cell M2 I entered =EDATE(K2,1) - This means that in cell M2 it will appear as the corresponding date of K2 but a month later (i.e K2 is 15/02/2019 M2 will automatically populate as 15/03/2019)
    However if K2 is empty, M2 appears as 31/01/1900

    I want this to be blank

    I therefore (rather hopefully) tried in M2 =IF(ISBLANK(k2),"", (=EDATE(K2,1))

    Can anyone make amends to that formula so that it works, or suggest an alternative method?

    Many thanks,
    Robbie
    Last edited by Robbieo19; 02-18-2019 at 04:30 AM. Reason: Solved

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,390

    Re: Add EDATE function into an IF function

    Normally I would do this:

    =IF(K2="","",your_formula)

    Try this:

    =IF(K2="","", EDATE(K2,1))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-02-2018
    Location
    UK
    MS-Off Ver
    1809
    Posts
    5

    Re: Add EDATE function into an IF function

    Thank you so much!! Worked perfectly first time!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,390

    Re: Add EDATE function into an IF function

    No problem!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,390

    Re: Add EDATE function into an IF function

    Just as an aside, you only need one = sign in a formula to have it recognised by Excel as such: right at the start.

  6. #6
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Add EDATE function into an IF function

    The error in your formula is the (= before EDATE.

    for every function or combination of functions you only use = as very first characther, when embedding/nesting a function in another function you cannot use = also there is an bracket error there should not be a opening bracket before EDATE

    try

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I colored the brackets to show how they pair, there should always be pairs

+ 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. EDATE and WORKDAY function help please
    By koala2015 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-22-2015, 07:32 PM
  2. IF statement not working with text function and edate function.
    By joshnathan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2013, 10:26 AM
  3. [SOLVED] Edate function Name error
    By SharonP. in forum Excel General
    Replies: 1
    Last Post: 05-02-2006, 02:25 PM
  4. [SOLVED] edate function:calculates days
    By I Cruz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2006, 03:50 PM
  5. [SOLVED] why won't EDATE function work in Excel?
    By Machead in a Microsoft World in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2006, 12:35 PM
  6. [SOLVED] edate function
    By Candace in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2005, 06:17 PM

Tags for this Thread

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