Results 1 to 18 of 18

calculating # of days from install to remove by address

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2015
    Location
    Colorado, USA
    MS-Off Ver
    2013
    Posts
    10

    calculating # of days from install to remove by address

    I'm a newbie to this group thanks for the awesome knowledgebase!

    My question is what is preferred conditional formula to determine number of days from "add" to "remove" (in SERVICE TYPE column) based on ORDER # (ORDER # is same as SERVICE ADDRESS fyi).

    Would you recommend using = DATEDIF and if so, how would the conditional part of the formula be written? I am struggling to figure out an elegant way (& scale-able!) to do this

    sample data.jpg
    Last edited by denverdriveby; 06-02-2015 at 05:13 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 10-31-2014, 10:32 AM
  2. Replies: 2
    Last Post: 02-20-2014, 06:40 AM
  3. Calculating time elapsed in days and count days within same range
    By michellem410 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-19-2008, 01:13 PM
  4. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 01:05 AM
  5. Replies: 6
    Last Post: 09-06-2005, 12:05 AM

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