Excel 2007 : Excel nested if problems

[AccessGeek71]

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

[CheshireCat]

Try:

Please Login or Register  to view this content.

[AccessGeek71]

DOH - I was so frustrated with this seemingly easy formula I knew it would come down to silliness and I "why didn't I think of that?" moment..

Thanks - this works great - the funny thing is a tried an iteration of that - but I used Isnull where you have blank - and I used Now() where you have Today() -it didn't work - so I ended with the one I posted - most grateful to you!