Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Number of days (2007)

    Lounger's - I have this formula - =IF(G19="","",IF(I19<>"","Complete",IF(DAYS360(G19 ,TODAY())>0,DAYS360(G19,TODAY())&" days overdue","Action Underway"))).
    I need to amend this to calculate the numbers of days between date due (G7) and date complete (I7). So the "Complete" would indicated ie "Completed 1 day prior to the due date", or "Competed 2 days after the due date"

    The part of the formula after "Compete" is fine.

    Any thoughts?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Number of days (2007)

    Hi Dean,

    How about:
    =IF(G7="","",IF(I7<>"","Completed "&IF(DAYS360(G7,I7)>0,DAYS360(G7,I7)&" day(s) after",IF(DAYS360(G7,I7)<0,-DAYS360(G7,I7)&" day(s) before","on"))&" due date.",IF(DAYS360(G7,TODAY())>0,DAYS360(G7,TODAY() )&" days overdue","Action Underway")))
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Number of days (2007)

    Paul,

    Looks good - great thanks

Posting Permissions

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