Forum Discussion
IF NOW with Date and Data
I take attendance using a scanner device and an excel spreadsheet. I also have a gradebook in excel. I'm trying to do an IF THEN (NOW) type of scenario. For instance, if ZOE is in attendance on 3/8/2...
Snowman1977 The TODAY function might be a better function to use. Can you share the workbook, removing any sensitive data, to get a better idea of the data and how the two worksheets are related and differ from one another?