mematedavev
New Member
- Joined
- Jul 2, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi,
I have attached an example of the attendance spreadsheet I am using. I want to create a formula that tells me how many days since the most recent specific attendance code. All present codes are marked as / but any unauthorised days are O, Medical is M, authorised is C etc. I want to create a formula that tells me how many days it has been since a O/C/M code.
I have attached an example of the attendance spreadsheet I am using. I want to create a formula that tells me how many days since the most recent specific attendance code. All present codes are marked as / but any unauthorised days are O, Medical is M, authorised is C etc. I want to create a formula that tells me how many days it has been since a O/C/M code.