"ljuarez12" wrote:
A1 = Initial Date (Manually Entered)
B1 = Initial Due Date (Calculated via Formula
=IF(AND(A1<"",F1<""),"",IF(ISNUMBER(A1),(+A1+60) ,""))

Presumably, B1 should be:

=IF(OR(A1="",F1=""),"",IF(ISNUMBER(A1),A1+60,""))

although I don't know what F1 has to do with it. But that can be simplified
as follows:

=IF(OR(ISNUMBER(A1)=FALSE,F1=""),"",A1+60)

formatted as Date.


"ljuarez12" wrote:
C1 = Date of Completed Report (Manually Entered)
D1 = Meeting Due Date = (Calculated via Formula)
F1 = Transfer Date (not really need for this sample)

Formula(s) for D1 should state, if user enters a date in A1 then it
should calculate B1 plus 30 days. Then if user enters a date in C1, it
needs to compare the dates between C1 and B1 and if C1 is less than B1
then it should calculate C1 plus 30 days

D1 should be:

=IF(ISNUMBER(B1),IF(ISNUMBER(C1),MIN(B1+30,C1+30), B1+30),"")

formatted as Date.

Note that B1 is not a date if A1 is not a date (or F1 appears blank), so it
is not necessary to test A1 separately here.