Do you know if there is anyway I can get an equation to only apply to cells with information in?....eg. I have two collums, one with 'disposal dates' in and the other with 'extended disposal dates'. I would like to get the difference between them (Extended disposal dates- disposal dates) however not all of them have an extended disposal date, therefore some cells display as '#VALUE!' because its calculating the disposal date-blank cell.... How can i get round this?
Bookmarks