Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Assistance

Options
  • 23-07-2015 1:54pm
    #1
    extremehalo
    Registered Users Posts: 136 ✭✭


    Looking for assistance on a formula.
    Have two cells with dates, looking to minus the dates to find the number of days, but if one cell is empty that the value remains blank.

    Cell 1 22/07/2015
    Cell 2 23/07/2015

    =days(Cell2,Cell1) Result = 1 (day)

    If Cell 2 has no value(date) inserted I would like it to stay blank.
    Cell 1 will always have a 'start' date but cell 2 will be filled when possible.
    Hope I explained it well enough..


Comments

  • Options
    #2
    aoh
    Registered Users Posts: 148 ✭✭aoh


    =IF(ISBLANK(Cell2),"",DAYS(Cell2,Cell1))


  • Options
    #3
    extremehalo
    Registered Users Posts: 136 ✭✭extremehalo


    aoh wrote: »
    =IF(ISBLANK(Cell2),"",DAYS(Cell2,Cell1))

    Thanks aoh!


Advertisement