Detectiveclem
Active Member
- Joined
- May 31, 2014
- Messages
- 320
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hi can anyone help me with the correct formula I need to show the number of days overdue based on data in two other fields.
Field 1 [Date Reqired for Compliance] in which the user inputs the date when someone needs to have responded to a request.
Field 2 [Date Material received] the user inputs the date when items have been received.
Field 3 [Status] in this field I would a formula which will show 'Complete' if Field 2 has a date entered or, if it is blank then display 'Awaits' if the date in Field 1 has not been reached (based on todays date) or show the number of days overdue (like this "23 days overdue").
Thanks any help appreciated
Field 1 [Date Reqired for Compliance] in which the user inputs the date when someone needs to have responded to a request.
Field 2 [Date Material received] the user inputs the date when items have been received.
Field 3 [Status] in this field I would a formula which will show 'Complete' if Field 2 has a date entered or, if it is blank then display 'Awaits' if the date in Field 1 has not been reached (based on todays date) or show the number of days overdue (like this "23 days overdue").
Thanks any help appreciated