Results 1 to 3 of 3

aging formula with network days from start to today

Threaded View

eddienole aging formula with network... 08-30-2011, 10:00 AM
NBVC Re: aging formula with... 08-30-2011, 10:05 AM
eddienole Re: aging formula with... 08-30-2011, 10:43 AM
  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    Charlotte
    MS-Off Ver
    Excel 2010
    Posts
    26

    aging formula with network days from start to today

    =IF(AND(H753="",G753=""),"",IF(H753="",TODAY()-G753,H753-G753))
    Trying to make the above formula return the networkdays from Start date to Today if there isn't a completion date.
    In my data G is the start date and H is the complete date. If H is blank I need networkdays as of today.\

    Thanks in advance
    Last edited by eddienole; 08-30-2011 at 10:43 AM.

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