SOLVED

Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2945764%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2945764%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20questions.%20Let%20preface%20both%20questions%20with%20I'm%20not%20particularly%20tech%20savvy%2C%20I'm%20a%20nurse%20but%20my%20boss%20wants%20a%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20after%20a%20formula%20that%20I%20can%20use%20to%20calculate%20the%20percentage%20of%20days%20per%20month%20that%20something%20was%20checked.%20So%20for%20example%20in%20October%20there%20is%2031%20days%20and%20the%20item%20was%20checked%2029%20times%20so%20therefore%20I%20need%20the%20formula%20to%20calculate%20the%20percentage%20for%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20second%20formula%20I%20after%20which%20may%20be%20the%20same%20as%20the%20first%20is%20again%20to%20calculate%20a%20percentage%20but%20this%20time%20the%20item%20is%20only%20to%20being%20checked%20every%20Sunday%20so%20between%204%20or%205%20times%20a%20month%20depending%20on%20the%20given%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20someone%20can%20assist%20with%20this%20dilemma.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20Regards%3C%2FP%3E%3CP%3EJennifer%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2945764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2945978%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2945978%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1213452%22%20target%3D%22_blank%22%3E%40Jennifer1978%3C%2FA%3E%26nbsp%3BSee%20attached!%20Nothing%20fancy.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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   

2 Replies

@Jennifer1978 See attached! Nothing fancy.

best response confirmed by Jennifer1978 (New Contributor)
Solution

@Riny_van_Eekelen Thank you very much for your help it was extremely useful