okay - here is my problem. I have a spreadsheet and I want to calculate how many days there were between when the project closed (U) and when the documentation was provided (W). I want this formula to be in one cell. The problem is this:
U can be blank because the project hasn't closed yet, and/or W can be blank because we haven't recieved the documentation yet. My current formula:
=IF(U19=" ","",(IF(ISBLANK(W19)=" ",(today-U19),W19-U19)))

is working on a limited basis. What I want is this:
step 1 - If U is blank then leave it blank
Otherwise step 2 - if w is blank then take today’s date and minus U
Otherwise step 3 - take W and minus U

For Step 1 & 3 the formula works as required
For scenario two it doesn’t acknowledge today’s date – and calculates it as though there was no date at all (-40816)

any thoughts or ideas would be greatly appreciated.

Thanks