Interesting challenge...

[19nicos29]

Hello,

I have an interesting Excel 2007 problem. Well, it's a problem to me since I can't solve it. Hopefully my explanation is clear to you:

I am doing some simple calculations in excel where I have to calculate the amount of days between the columns 'sent out to approve documents' and 'approved documents'. I would like to track how much time it takes for each document (row) from the date I sent the doc out to the date it was actually approved. In case it's not approved yet BUT sent out before I am counting from the day I sent it out to today's date (now() ).
I don't want to show a value in either of the two columns and would like to show a value in the calculating cell (# of days) for all the possible scenarios (sent out but not approved yet / sent out and approved).

How can I do this? I got far, but not there yet. This is what I did:
I use 'IF(0, Then, NOW())' for the cells where no date is included yet and use ';;;' to hide this value. Furthermore, in the calculating cell (#days) I put '0;-0;;@' in the format to hide zeros. The calc is: 'cellY-cellX'.
The problem is that when I hide the cells with 'IF(0, Then, NOW())' and want to put the actual date in when it's approved or sent out, it hides (because of the ;;.

There must be a solution to this and it would be awesome if someone could help me!

Thanks,
Nick

[VBA Noob]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.