This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a very simple problem that I just can't get to work ...
I have a Contract date in column C
The Return date in column D =c5=30
Today in column E Today()
How many days left in column F =IF(C9,"", D9-E9)
How many days out in Column G =IF(F5>6,"","Days Out")
Call Client in Column H =IF(F5>6,"","Follow-up ~ Call Client")
The problem ...
If I don't have a date in Column C - I don't want to see anything in Column F
So I put =if(c5,"",D5-E5)
it gives me a -42001 instead of leaving the cell blank.
and I want it to say if F5 is less that 0 Expired
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
oops, I didnt realize your formula is in column F, it should be
=IF(C5="","",IF(D5-E5<0,"Expired",D5-E5))
You're the Greatest!
Hello Wyman.
It says " Circular Reference Warning"
I have a date in Column C
| 1/1/2015 | 1/31/2015 | 1/27/2015 13:52 | 3.4 | Days Out | Follow-up ~ Call Client |
|---|
when I put your formula in F5 I get
| 1/1/2015 | 1/31/2015 | 1/27/2015 13:55 | 0 | Days Out | Follow-up ~ Call Client |
|---|
Try
IF(ISBLANK(C5),"",IF(D5<E5,"Expired",D5-E5))
=if(c5="","",if(F5<0,"Expired",D5-E5))