Closed Thread
Results 1 to 7 of 7

Count days in a rolling 12 month period

  1. 11-08-2014, 08:52 PM #1
    mlafrance
    mlafrance is offline
    Registered User
    Join Date
    11-20-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    24

    Count days in a rolling 12 month period

    I have a spreadsheet with date arrived in column A and date departed in column B. Column C contains the difference between the two, thus number of days in location. I'm using Excel 2010. I'd like to count the number of days in location over a rolling 12 month period. Thank you for any help or pointers anyone can give.
    Reply With QuoteRegister To Reply
  2. 11-08-2014, 09:00 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Count days in a rolling 12 month period

    Hard to offer precise suggestions without seeing what you are working with, but try something like this...
    =EDATE(TODAY(),-12)

    This will give you exactly 12 months back from today
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 11-08-2014, 09:23 PM #3
    mlafrance
    mlafrance is offline
    Registered User
    Join Date
    11-20-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Count days in a rolling 12 month period

    Ford,
    Thank you for responding.
    Here is something similar to what I have -
    Attached is a sample of my data. I need to tabulate the number of days on location on a rolling 12 month period.
    Mike
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-08-2014, 10:36 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Count days in a rolling 12 month period

    Im not sure what you mean by rolling 12 months, your dates are at mosr 18 days apart, and the latest is 25 Oct 14.

    Can you show some sample answers?
    Reply With QuoteRegister To Reply
  5. 11-13-2014, 02:08 PM #5
    mlafrance
    mlafrance is offline
    Registered User
    Join Date
    11-20-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Count days in a rolling 12 month period

    Thanks for the help. I've resolved the problem.
    Reply With QuoteRegister To Reply
  6. 09-30-2023, 07:06 AM #6
    nikhilkdipsar
    nikhilkdipsar is offline
    Registered User
    Join Date
    09-30-2023
    Location
    London
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20182) 64-bit
    Posts
    1

    Re: Count days in a rolling 12 month period

    hi mlafrance, I am also looking for a solution to same problem. Could you help me with that?
    Reply With QuoteRegister To Reply
  7. 09-30-2023, 07:45 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,244

    Re: Count days in a rolling 12 month period

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #1 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count days per month within a period
    By Cunner in forum Excel General
    Replies: 4
    Last Post: 02-03-2014, 06:12 AM
  2. 12 month rolling period with variable dates over the 12 month period
    By ChrissyP2 in forum Excel General
    Replies: 10
    Last Post: 01-09-2014, 07:04 PM
  3. Remove missed days after 12 month rolling period
    By gopherc4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2009, 06:12 PM
  4. How to count dates in a 12 month rolling period
    By butlej6 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-05-2008, 06:00 PM
  5. How do I count dates in a 12 month rolling period?
    By butlej6 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2008, 05:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1