+ Reply to Thread
Results 1 to 4 of 4

Days late formula returning 4139 in date field

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    herts
    MS-Off Ver
    2010
    Posts
    6

    Days late formula returning 4139 in date field

    Hi all I am a newbie on here and finding my way around excel. My business create quotes and these quotes have allocated times for completion depending on their difficulty. I have three types of quotes and three seperate allocation of days to do them.

    I have formula's to get the number of days late =TODAY()-H3 with H3 being the due date. however when I drag the formula down as soon as it hits a cell on row H without a date (ie when there is not a quote logged on that line) it automatically returns a 4139 number in the field.??

    is there any better way to do this. I basically need to log how many quotes are behind schedule by counting which due date is less than today?? I'm sure I'm just running around the block here rather than going in a straight line..Matt Tracker (DO NOT USE).xlsx

    any help would be much appreciated

    Kind Regards

    Marcus

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Days late formula returning 4139 in date field

    Perhaps in N3 and copy down.

    =IF(H3>0,TODAY()-H3,"")
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    06-14-2013
    Location
    herts
    MS-Off Ver
    2010
    Posts
    6

    Re: Days late formula returning 4139 in date field

    two days thats taken me and you solve it in half an hour!!

    Awesome thank you so much!!!

    Marcus

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Days late formula returning 4139 in date field

    Welcome to the ExcelForum!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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