Forum Discussion

ShaneATV's avatar
ShaneATV
Copper Contributor
Oct 10, 2024

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

 

Resources