Forum Discussion
I need help writting a complex formula involving dates
Hi, I have a complex formula that I need to write involving dates. I have students that are handing in an assignment. I have a due date column. I then have "grace" period of one week....
Hi Nicole,
That could be like this
Hi Nicole,
It depends on how do you calculate weeks - is that calendar 7 days or you exclude public holidays and/or weekends; if the exam passed in 27 days from due date (i.e. 3 weeks and 6 days) is that considered as 3 weeks or 4 weeks delay?
Hi Sergie,
Its calendar days regardless of public holidays
- It is calendar days regardless of public holidays and it has to be full weeks
Hi Nicole,
That could be like this
- Sergei,
That is perfect - Thank you
