+ Reply to Thread
Results 1 to 3 of 3

Blank function/Null function for missing dates

  1. #1
    Registered User
    Join Date
    05-17-2010
    Location
    Albuquerque, NM
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Blank function/Null function for missing dates

    Hello I have an excel spreadsheet that has dates of when a project report was originally sent to the client (D2, D3, etc.,) and I have dates of when we finally received payment for the report (M2, M3, etc.,). As well I have a column that counts the days between these two time frames (N2, N3) so we can figure out how long it takes to receive payment. (=M2-D2, =M3-D3, etc.,).

    My problem is that when there isn't a date in the payment received column (M3 in the spreadsheet below), that it brings over the date from D3 in a number format into the Total Number of Days to Receive Payment column (N3) and doesn't look right. How can i create a function to automatically update N3 (Total # of days column) when there's a number in M3 but to stay blank if M3 is blank.

    Take a look at my spreadsheet and see if this makes sense Thank you! you are GREATLY appreciated. I work and work and work on these till I feel like I want to pull my hair out, and then I give it to the masters to show me how it's done.

    Attached Files Attached Files
    Last edited by knowledgeiskey; 05-21-2010 at 05:02 PM. Reason: Clarification

  2. #2
    Forum Contributor
    Join Date
    05-16-2010
    Location
    UK
    MS-Off Ver
    2003 and 2007
    Posts
    252

    Re: Blank function/Null function for missing dates

    Is this what you want? Type this in N3:

    =IF(M3="","",M3-D3)

  3. #3
    Registered User
    Join Date
    05-17-2010
    Location
    Albuquerque, NM
    MS-Off Ver
    Excel 2007
    Posts
    4

    Thumbs up Re: Blank function/Null function for missing dates

    Quote Originally Posted by pb71 View Post
    Is this what you want? Type this in N3:

    =IF(M3="","",M3-D3)
    YOU ARE AWESOME!!!! . . yes that's EXACTLY what I NEEDED! . . gosh you are too good lol or I am very slow when it comes to this stuff :| . . but I really appreciate your help

+ Reply to Thread

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