+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 19 of 19

final date formula not work

  1. #16
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,011

    Re: final date formula not work

    Hi oeldere is perfect!
    A small change for cell F5
    If cell C6 is empty the valid cell is F7
    if cell c6 is not empty the valid cell is F5
    max_max
    Attached Files Attached Files

  2. #17
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,321

    Re: final date formula not work

    f5 =IFERROR(EDATE(F7,-F6),"")

    Edit:

    The correct formula has to be:

    =IF(C6="",F7,EDATE(F7,-F6))
    Last edited by oeldere; 09-14-2017 at 02:33 PM. Reason: edit added
    Notice my main language is not English.

  3. #18
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,011

    Re: final date formula not work

    Thanks you oeldere, it's perfect!
    A greeting
    max_max

  4. #19
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,321

    Re: final date formula not work

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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