|Thanks, that worked!|
It has now caused another issue, but more for looks rather than anything else but if there is a soloution great!
Lodged Due Date Overdue Extension
12/1/2009 3/1/2010 24 10
blank blank #VALUE!
the formulas I used are, yours for the 'due date' and the 'Overdue' =IF(B5-C1-E1>0,B5-C1-E1,0). B5 is the current date 'TODAY()'. C is the 'Due Date' and E is the 'Extension'
As you can see it works well when dates are inserted but returns a value error when it is blank. The formula is changed as the rows go down.