How to make an attendance sheet that displays missing days

how are you going to layout the sheet
you could use conditional formatting to highlight missed days and times
but that depends on how you intend to complete the sheet

if you had names down the column in each row and dates across the columns so in Row1
then you have a matrix - that can then be completed

As you also want times - then you would need to think about how they would be entered
is this the same time every day for a student or does it vary -

a little more info is needed really

perhaps try setting up a draft spreadsheet and attaching here

use COUNTIF()
to sum up cells with a criteria

=COUNTIF( range of cells , "N/A" )
that will count all the cells that have N/A in


To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

you can use countif()

assuming the checked out column will always have N/A
=COUNTIF(D:D,"N/A")

and the time for 16:30
=COUNTIF(D:D,">"&TIME(16,30,0))

see attached

you can click on add reputation - thats all

Thanks