Different Functions in One Cell Cancel Each Other Out - How can I fix this?

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,"")
 
J

joeu2004

ljuarez12 said:
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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top