L
ljuarez12
Hi, Please help. I have tried to setup my formulas in so many ways an
still cannot get the results. If I move them to different cells the
work independently however once I place them together the first cancel
the second one out and it does not work. Here is the sample.
A1 = Initial Date (Manually Entered)
B1 = Initial Due Date (Calculated via Formul
=IF(AND(A1<>"",F1<>""),"",IF(ISNUMBER(A1),(+A1+60),""))
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 i
should calculate B1 plus 30 days. Then if user enters a date in C1, i
needs to compare the dates between C1 and B1 and if C1 is less than B
then it should calculate C1 plus 30 days (in other words if the date o
report was completed prior to the due date then a new one needs to b
calculated).
Here is the formula I have now...again, I tried to change it up but thi
was my last one I tried using and it just gave me a False as a retur
statement. =IF(ISNUMBER(A1),(+B1+30)&IF(C1<B1,+C1+30,"")
still cannot get the results. If I move them to different cells the
work independently however once I place them together the first cancel
the second one out and it does not work. Here is the sample.
A1 = Initial Date (Manually Entered)
B1 = Initial Due Date (Calculated via Formul
=IF(AND(A1<>"",F1<>""),"",IF(ISNUMBER(A1),(+A1+60),""))
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 i
should calculate B1 plus 30 days. Then if user enters a date in C1, i
needs to compare the dates between C1 and B1 and if C1 is less than B
then it should calculate C1 plus 30 days (in other words if the date o
report was completed prior to the due date then a new one needs to b
calculated).
Here is the formula I have now...again, I tried to change it up but thi
was my last one I tried using and it just gave me a False as a retur
statement. =IF(ISNUMBER(A1),(+B1+30)&IF(C1<B1,+C1+30,"")