Closed Thread
Results 1 to 3 of 3

calculation of days & usage

  1. #1
    Registered User
    Join Date
    09-15-2020
    Location
    India
    MS-Off Ver
    365
    Posts
    38

    calculation of days & usage

    HI,

    Check for same sr. no
    If single, then result should come as "No comparison"
    If double then difference of usage & days should come excluding the no. of holidays during that period
    If multiple, then result should come as difference of usage should come in comparison to last usage & similarly the difference of days excluding the holidays during that period.

    Result expected also shared in attached excel.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,060

    Re: calculation of days & usage

    Please read the forum rules. Duplicat threads are NOT allowed.

    Please continue in your original thread, where you already have one reply. This thread is now closed.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,060

    Re: calculation of days & usage

    This is the second time in recent weeks that you have opened a duplicate thread. If you continue to do this, you can expect to get a temporary BAN from this site.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cumulative period days calculation deduct the agreed fob days
    By abuharvey in forum Excel General
    Replies: 4
    Last Post: 04-09-2020, 05:44 AM
  2. Calculation of Peak license usage in a given interval
    By yskreddy123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2018, 03:29 AM
  3. [SOLVED] Usage calculation
    By nickcooluz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-25-2015, 11:29 AM
  4. [SOLVED] Min / Max Usage Calculation
    By jasonjholt in forum Excel General
    Replies: 2
    Last Post: 08-11-2015, 07:32 AM
  5. [SOLVED] Calculation of days between days and time
    By theprincesunil in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-27-2014, 03:09 PM
  6. [SOLVED] Pivot table / usage calculation
    By cory0789 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2014, 02:22 AM
  7. [SOLVED] Please Help With Days Elapsed And Days Remaining Calculation
    By Scoooter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2006, 12:15 PM

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