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

​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 dateYes – Submitted * day(s) early            {Based on how many days it was submitted before 28 October}Mock example below   Read More

​