Nov 09 2021 07:40 PM - edited Nov 09 2021 07:42 PM
Hi All,
I have two questions. Let preface both questions with I'm not particularly tech savvy, I'm a nurse but my boss wants a spreadsheet. I am using Windows 10 on a PC with Office 365.
I'm after a formula that I can use to calculate the percentage of days per month that something was checked. So for example in October there is 31 days and the item was checked 29 times so therefore I need the formula to calculate the percentage for me.
The second formula I after which may be the same as the first is again to calculate a percentage but this time the item is only to being checked every Sunday so between 4 or 5 times a month depending on the given month.
Hopefully someone can assist with this dilemma.
Kind Regards
Jennifer
Nov 11 2021 05:29 PM
Solution@Riny_van_Eekelen Thank you very much for your help it was extremely useful :)
Nov 11 2021 05:29 PM
Solution@Riny_van_Eekelen Thank you very much for your help it was extremely useful :)