Hello,
I am making a attendance spreadsheet. my current formula is =IF(DATE=TODAY(),STATUS,"")
DATE is a column with sequential dates by 5 day increments.
TODAY() is the the current date for today.
STATUS is what attendance condition they are in, here, day off, annual, sick, late.
The formula works for one day, the day that matches today's date. The problem I cant figure out is how to change the formula to keep the data from previous days from going blank once the date cell doesn't match the date of today.
Bookmarks