Forum Discussion
ShaneATV
Oct 10, 2024Copper Contributor
Excel Date Formula for On-time reporting
Hi,
I'm wanting to create a formula for creating an automatic statement as to whether a report has been submitted on time or not. The report due date doesn't change, it's always due on 28 October for the current year. I'm guessing there will be a lot of IF statements as I'm wanting it to say:
No - Submitted * day(s) late {Based on how many days it was submitted after 28 October}
Yes - Submitted on due date
Yes - Submitted * day(s) early {Based on how many days it was submitted before 28 October}
Mock example below
- Riny_van_EekelenPlatinum Contributor