Results 1 to 2 of 2

Interesting Excel challenge

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2009
    Location
    LA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Interesting Excel challenge

    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
    Last edited by VBA Noob; 04-08-2009 at 04:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1