Multiple Functions to one or more cells

**ljuarez12** · 10-21-2011, 01:22 AM

Hi, I really need the right formula to add. I have tried several and continue to receive an error. I am able to get =IF(ISNUMBER(a1);WORKDAY(a1;43);"") with no issue but when I add further info to it, ie another IF statement I receive an error. Here is what I am trying to accomplish.

A1 = Referral Date
B1 = Transfer Date
C1 = Referral Due Date
D1 = Transfer Due Date

If A1 is entered then C1 will calculate the due date, via the formula above, B1 and D1 = blank
If A1 & B1 both have dates then D1 should calculate 30 days out and C1 = blank

Also, not really sure if I need to place both if statements in C1 or does it have to be broken into two cells. Please help! Thanks. Sorry haven't worked with excel formulas in too many years.

**TMS** · 10-21-2011, 03:09 AM

You could have:

C1: =IF(AND(A1<>"";B1<>"");"";IF(ISNUMBER(A1);WORKDAY(A1;43);""))

However, there is a problem with the statement.

If A1 is entered then C1 will calculate the due date, via the formula above, B1 and D1 = blank

A cell either has a value or a formula. If yo want to type a date into cell B1, it can't have a formua which will make it blank depending on the value in another cell.

You could probably do that with a VBA Worksheet Change Event monitoring columns A and B ... do you want a VBA solution?

Regards