Results 1 to 12 of 12

How to calculate number of days per year a customer is a member

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-31-2012
    Location
    Norway
    MS-Off Ver
    Excel in Office 365
    Posts
    147

    How to calculate number of days per year a customer is a member

    Hi,
    I was wondering if anybody could help me with a formula in the attached file? I need to find out how many days per calendar year a customer is active. The membership often starts from august to august. But there are many customers who have different membership period, and they might alter from one year to another.

    Let me know if I need to describe it better.

    Thanks for the help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate age if there were 112 days in a year
    By army in forum Excel General
    Replies: 7
    Last Post: 12-09-2014, 04:59 PM
  2. [SOLVED] How to calculate Year, Month and Day from total number of days?
    By Indra Rai in forum Excel General
    Replies: 4
    Last Post: 06-25-2014, 02:08 PM
  3. Replies: 15
    Last Post: 06-03-2014, 02:08 PM
  4. Calculate Leave Accural In a year using staff member tennur
    By SalientAnimal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2014, 06:54 AM
  5. Replies: 8
    Last Post: 05-10-2013, 05:37 AM

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