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
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Assistance

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


    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

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


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


  • #3
    extremehalo
    Registered Users Posts: 138 ✭✭extremehalo


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

    Thanks aoh!


Advertisement