+ Reply to Thread
Results 1 to 2 of 2

Nested IF function to count days from milestone dates

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    CT
    MS-Off Ver
    2012
    Posts
    1

    Nested IF function to count days from milestone dates

    I have a spreadsheet (attached) that give me 5 dates of certain company milestones, I need to code the report so that I can count the days between each milestone for instance:

    If G2 and H2 are blank, return a zero in C2
    If G2 has a date but H2 is blank, return Todays date – G2 in C2
    If G2 and H2 both have a date, return H2-G2 in C2

    I was trying something like this but cant figure it out [=IF(AND(ISBLANK(G4),ISBLANK(H4)),0,IF(AND(ISBLANK(H4),ISBLANK(G4)=FALSE),TODAY()-G4, H5-G4)]

    Thanks for any advice!

    Glen
    Attached Files Attached Files

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Nested IF function to count days from milestone dates

    Hi,

    Check the attached file and hope this will help you:

    Milestone Metrics.xlsx

    Note: I have entered the formula in M2 and M3.

    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

+ 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. [SOLVED] Vlookup dates between two dates and count the number of days
    By nishikanth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2013, 03:25 AM
  2. Replies: 5
    Last Post: 08-29-2012, 05:25 PM
  3. How can I populate milestone dates for more than one outcome excel
    By Bayebd24 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2012, 12:31 PM
  4. Count days between dates
    By Brandy in forum Excel General
    Replies: 9
    Last Post: 08-07-2010, 10:45 AM
  5. Replies: 7
    Last Post: 01-16-2009, 05:04 AM

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