Hello,

I was wondering if anyone could help me out.. I am having such a hard time with these forumlas. I'm sure it a very easy fix but just cant seem to get it down..

I am trying to get the forumla for column K6(due dates) and I will have blanks in column L6(completed dates) due to all the employees not having completed the assignment. Anything pass 30 days of the start date is considered late and I need a spreadsheet to populate these past due dates.


I have been using:

=IF(ISBLANK(L6),NOW()-I6,L6-I6)

I6= start date
K6= due date
L6= completed date

I guess I am confused because on the code for the userform it does not mention columns I,K or L

userform code

Private Sub cmdOverdue_Click()
'error statement
On Error GoTo errHandler:
'clear the listbox
lstLookup.RowSource = ""
'clear controls
Me.txtLookup.Value = ""
Me.cboStart.Value = ""
'add department and date range to criteria
With Sheet2
.Range("P7").Value = ""
.Range("Q7").Value = ""
.Range("R7").Value = Me.cboDepartment.Value
.Range("O7").Value = "=""<=""&TODAY()"
End With
'run the filter
AdvFilter
'check for value and adjust rowsource to avoid an error
If Sheet2.Range("T7").Value = "" Then
lstLookup.RowSource = ""
Else
lstLookup.RowSource = "Filter_Staff"
End If
'error block
On Error GoTo 0
Exit Sub
errHandler::
MsgBox "An Error has Occurred " & vbCrLf & "The error number is: " _
& Err.Number & vbCrLf & Err.Description & vbCrLf & _
"Please notify the administrator"


so what am I doing wron?? please help me

thanks,
brwnrootsister