Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range and dates
I am trying to keep track of attendance. I want to be able to retrieve dates
of when a student is absent. How can I do that? "Student I.D. #" Last Name First Name 12/1/05 12/2/05 12/3/05 12/04/05 Student Example Absent Absent When I do my report, I want to be able to get the date the student was absent. I need help on my formula. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range and dates
Last date?
Just use =INDEX(1:1,MATCH(9.99999999999999E+307,2:2)) assuming the data is in row 2, dates in row 1. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Mike" wrote in message ... I am trying to keep track of attendance. I want to be able to retrieve dates of when a student is absent. How can I do that? "Student I.D. #" Last Name First Name 12/1/05 12/2/05 12/3/05 12/04/05 Student Example Absent Absent When I do my report, I want to be able to get the date the student was absent. I need help on my formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
count date occurances in range of dates... | Excel Worksheet Functions | |||
Finding dates within a date range | Excel Worksheet Functions | |||
Finding Dates in a date range | Excel Discussion (Misc queries) |