I have an excel spreadsheet where I calculate network days between two different dates excluding holidays and weekends. I have the formula right and once I enter the dates I just drag the formula down. My problem is that my dates are scattered through the spreadsheet so after I have dragged the formula down I have to go back and remove the negitive results because dates were not entered.
Is there a way to format the column so that once the dates are entered it will calculate the network days rather than me dragging down the formula?
could you please supply the formula that you are using, i will have a look and make adjustments as necessary.
what you need to do is write the formula along the lines on only action the cell if there is an entry in the cell otherwise make it blank.
I could explain better if I saw what the formula was that you are using.