Is there a formula that automatically inserts a "yes" or "no" if a deadline for an incident report was met or unmet?
Hello, I'm in charge of creating a log of incident reports and I'm wondering if I can easily automate some of the data if reports were submitted late in relation to when the incident happened. Is there a formula for this?
For example, we're mandated to submit reports within three days of an incident occurring. So if the incident occurred on 01/01/2026 and the report was turned in on 01/04/2026, the report met the deadline--but if the report was turned in on 01/05/2026, it's considered late.
The policies disregard time, so it's just the calendar date that's important.
I can't find anything on Google specific to what I need. Thank you in advance!
Edit: Apologies! I forgot to mention, if the last day the report is due (the third day following the day of the incident) falls on a weekend or a (state) holiday, the incident is due on the next business day. For example if the incident occurred on Tuesday, 07/01/2025, the due date would've been on Friday, 07/04/2025, but because that day is considered a holiday in my home state, the report needed have been submitted on Monday, 07/07/2025 (before 12:00 AM, Tuesday, 07/08/2025) at the latest to make the deadline. Another thing I forgot to mention is that if an incident occurred on a weekend, let's say Saturday, 04/04/2026, the report is still due within three days from that Saturday; so the last day would be Tuesday, 04/07/2026 before 12:00 AM of Wednesday, 04/08/2026. Someone did mention a way to account for holidays and weekends below, so I'll experiment with that formula to see if this dilemma is solved or not. Again appreciate all the help!
[link] [comments]
Want to read more?
Check out the full article on the original site