IF NOW with Date and Data

%3CLINGO-SUB%20id%3D%22lingo-sub-2195772%22%20slang%3D%22en-US%22%3EIF%20NOW%20with%20Date%20and%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195772%22%20slang%3D%22en-US%22%3E%3CP%3EI%20take%20attendance%20using%20a%20scanner%20device%20and%20an%20excel%20spreadsheet.%20I%20also%20have%20a%20gradebook%20in%20excel.%20I'm%20trying%20to%20do%20an%20IF%20THEN%20(NOW)%20type%20of%20scenario.%20For%20instance%2C%20if%20ZOE%20is%20in%20attendance%20on%203%2F8%2F2021%2C%20I%20want%20the%20gradebook%20to%20record%20an%20%22X%22%20for%20a%20student%20named%20Zoe%20because%20she%20was%20present.%20If%20she%20were%20not%20listed%20on%20that%20specific%20date%2C%20then%20it%20would%20put%20an%20%22A%22%20for%20absent.%20This%20is%20between%20two%20sheets%20in%20the%20same%20excel%20file.%20Can%20anyone%20help%20me%20with%20the%20correct%20IF%20arguments%20because%20I'm%20having%20difficulty%20getting%20this%20right.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2195772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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/2021, I want the gradebook to record an "X" for a student named Zoe because she was present. If she were not listed on that specific date, then it would put an "A" for absent. This is between two sheets in the same excel file. Can anyone help me with the correct IF arguments because I'm having difficulty getting this right. 

2 Replies

@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?

It would be reasonable to assume to reason that if they do not sign in they are absent so why would you need to record X is for absent