I have looked through and tried many items posted already but am still getting an error.
I have a spreadsheet as such:
Name, Staff, Referral Date, Intake Due, Intake Date, Outcome Met?.......
My current set up:
C3 -Referral Date is manually entered.
D3 - Intake Due is 7 days from Referral Date thus =IF(ISBLANK(C3),"",C3+7)
E3 - Intake Date is manually entered
F3 - Outcome Met? compared Intake Due and Intake Date for the 7 day period thus =IF(E3<=D3, "Yes","No") --- This then is used somewhere else to calculate a percentage which is working correctly.
PROBLEM - Right now the F will say Yes if there is no date in Intake Date - how do I have it complete the formula ONLY if data is filled in? This is where I have looked up many other threads and tried the formulas outlined. I want F to remain blank if E is blank. Because these 'invalid' fields are calculating out as Yes, my percentage formula is counting them which I do not want. Error I receive says Too Many Arguments.
Any help greatly appreciated.
I have a spreadsheet as such:
Name, Staff, Referral Date, Intake Due, Intake Date, Outcome Met?.......
My current set up:
C3 -Referral Date is manually entered.
D3 - Intake Due is 7 days from Referral Date thus =IF(ISBLANK(C3),"",C3+7)
E3 - Intake Date is manually entered
F3 - Outcome Met? compared Intake Due and Intake Date for the 7 day period thus =IF(E3<=D3, "Yes","No") --- This then is used somewhere else to calculate a percentage which is working correctly.
PROBLEM - Right now the F will say Yes if there is no date in Intake Date - how do I have it complete the formula ONLY if data is filled in? This is where I have looked up many other threads and tried the formulas outlined. I want F to remain blank if E is blank. Because these 'invalid' fields are calculating out as Yes, my percentage formula is counting them which I do not want. Error I receive says Too Many Arguments.
Any help greatly appreciated.
