+ Reply to Thread
Results 1 to 4 of 4

Need HELP! need to create a 6 month rolling calendar or reversal ( New to Excel)

  1. 07-11-2014, 05:29 PM #1
    Brooke558
    Brooke558 is offline
    Registered User
    Join Date
    07-01-2014
    Location
    Fort Wayne IN
    MS-Off Ver
    2013
    Posts
    2

    Need HELP! need to create a 6 month rolling calendar or reversal ( New to Excel)

    Okay so I need to create an attendance sheet that basically stays current. I don't want to manually add up point within a 6 month time frame. So I need any points accumulated after 6 months to not go within the total points. So for example today is July 11th. So anything older than 1/9/2014 should automatically not be counted. I did today's date - 183 to get to 1/9/2014 seeing as there are 365 days in a year. I'm open to any suggestion, need to create a low maintenance attendance sheet for my boss ASAP. Just having a problem on how to actually make it low maintenance!


    I can email what I have so far, can't get to upload on here.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-11-2014, 06:30 PM #2
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Need HELP! need to create a 6 month rolling calendar or reversal ( New to Excel)

    This will work for your example. I'm not sure of the layout of the rest of the data so you would need to adjust it yourself for other employees.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    or
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.
    Reply With QuoteRegister To Reply
  3. 07-11-2014, 06:53 PM #3
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Need HELP! need to create a 6 month rolling calendar or reversal ( New to Excel)

    I inserted a couple of formulae to help you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-14-2014, 01:02 PM #4
    Brooke558
    Brooke558 is offline
    Registered User
    Join Date
    07-01-2014
    Location
    Fort Wayne IN
    MS-Off Ver
    2013
    Posts
    2

    Re: Need HELP! need to create a 6 month rolling calendar or reversal ( New to Excel)

    Thank you sooooo much for helping me!
    Reply With QuoteRegister To Reply
+ Reply to 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. Attendance Point System Spreadsheet with Rolling 1-year Points Reversal
    By mfoley9723 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2018, 04:46 PM
  2. 6 month rolling attendance calendar
    By mdobbins in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2013, 04:12 PM
  3. Attendace tracking with 12 month rolling calendar and different types of absences
    By aboston in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-25-2013, 02:29 PM
  4. How to create a Rolling Month Formula.
    By singerbatfink in forum Excel General
    Replies: 3
    Last Post: 11-19-2010, 06:37 AM
  5. Rolling 3 Month Calendar
    By supachoc in forum Excel General
    Replies: 3
    Last Post: 10-18-2010, 04:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1