+ Reply to Thread
Results 1 to 7 of 7

Weekly Attendance Log for school

  1. #1
    Registered User
    Join Date
    09-18-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Weekly Attendance Log for school

    what formula can i use to fill in the Days of the week with the Date each month just by changing the Month in different Box?
    i need the mon thru fri (4 weeks for each month) to automatically change to the correct date for each weekday?


    attendance log.JPG
    Last edited by iceydrums; 09-18-2020 at 06:45 PM. Reason: adding file

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Weekly Attendance Log for school

    Welcome to the forum

    This would be much easier if we had a sample Excel file, not just a picture. See the yellow banner at the top of your thread.

    If cell C2 is where your month will go, then make sure to enter a real date, like 1-sep-20. You can then, if you wish, format C2 with custom format "mmm" so that C2 would display as "Sep".

    Assuming your dates start in H4, then in cell H4:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In cell I4 and copied right as far as you need:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Format row-4 as a date in whatever form you like.
    now
    Where you have Mon, Tue, Wed and so on I would derive these from the date row that you just added. So assuming you want your days starting in cell H3 then in H3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Copy right as far as you need. Now format row3 as: "ddd". The cells contain dates but the format will display only the "day" part of the date.

    Another option would be to have just one row with your day plus date. You would simply format the row as "ddd mm/dd" or something similar.

    Hope this helps. If it's not clear then upload a workbook and we can provide more precise feedback
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select ?Solved? from the Thread Tools menu

  3. #3
    Registered User
    Join Date
    09-18-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Re: Weekly Attendance Log for school

    i think i have added the file that i use for this. i would also need the file to update if possible each month that i change to.
    that way each day if filled in for me instead of having to go in each time to do it manually. (if it can be done)
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Weekly Attendance Log for school

    Enter a date in C2 like 10/1/20 that is the first of the desired month (NOT just a month name!)
    Custom formant C2 as "mmm"

    In H3 copied across to AF3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Custom format H3:AF3 as "ddd dd" or as desired.

    As the custom format in row-3 includes the day name I did not populate row-4.

    An updated version of your workbook with the above changes is attached

    Hopefully this is what you are looking for. Let us know.
    Attached Files Attached Files

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Weekly Attendance Log for school

    1) If C2 is first day of Month,i.e, 10/01/2020:
    In H3 then copy accross:
    Please Login or Register  to view this content.
    2) If C2 is kept as month in text, i.e, Oct, Nov ,... of the year 2020:
    Please Login or Register  to view this content.
    Copy accross
    Quang PT

  6. #6
    Registered User
    Join Date
    09-18-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Re: Weekly Attendance Log for school

    that was perfect. the next challenge if possible, would there be a way to make it only show the days that are in that month and not the extra?

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Weekly Attendance Log for school

    Try again:
    Please Login or Register  to view this content.

+ Reply to Thread

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: 03-11-2020, 01:45 PM
  2. Replies: 1
    Last Post: 01-30-2020, 11:37 PM
  3. School Attendance Register- Calculating for half day withdrawal
    By kurtyranks in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-29-2016, 06:15 AM
  4. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  5. Trying to calculate school attendance in Excel 2010
    By barclaygp in forum Excel General
    Replies: 7
    Last Post: 08-24-2012, 10:00 AM
  6. Preparing Weekly attendance Percentage of Agents
    By luckyros in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-27-2008, 09:49 PM
  7. Summarize employee attendance data on a weekly basis
    By Hanr3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2006, 12:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1