Calculating % Sickness based on days in month

Currently the workbook i am using calculates % Sickness based on FTE (Full Time Equivalent) * 37.5

Formula:

Please Login or Register  to view this content.

where:

G:G - Hours lost in month to sickness
Master Staff Database.xlsm]Staffing details'!$K$107 - FTE figure

What I am wanting to do is calculate this for the actual number of days in the month, but currently EVERY month only assumes that everyone works 37.5 hours a week, but i would like to effectively calculate

Sickness/(FTE*(37.5/(5*Days_In_Month)))

i know I could add 12 Embedded IF Statements, but i am sure there is a more appropriate way of calculating it.

Thanks Trevor.

I now have

Formula:

Please Login or Register  to view this content.

I appreciate 37.5*4/28 could be simplified as they are constant, but I wanted to make sure that if/when I left whoever uses the Workbook can simply see the maths rather than seeing a "random" 5.35714.

TBF I've never really thought of using Named_Range for single cells.

Formula:

Please Login or Register  to view this content.

Data is on a separate worksheetAttachment 862159

Taken on board what you said about data looking like Cell References so have changed it to

Formula:

Please Login or Register  to view this content.