Help with formatting Formula using IF statement

Not sure what yr workbook looks like, but I assume there will be some kind of table holding the hours worked of employees per month.
The attached sample shows some formulas using IF to calculate what you need (as far as I understand).

It shouldn't really be a problem whether hrs are entered per day, per week or per month. Could probably be done with a similar formula.
Can you upload yr workbook and post any specific problems you're facing. If any of course

To help you construct a working formula is better to have the workbook so I can see what excatly you're entering in the cells you mention.
To upload yr workbook:
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
In the upload window select the workbook and click [Upload].
When the file is uploaded click [Close window].

Please see attached, thanks for your help!

OK. I think this formula could calculate the days to plot:

Formula:

=IF(D19<>"",

    IF(AND(D42<=5,D20="Monthly",D21="Yes"),

       D43-1,

       IF(D20="Weekly",

          D19-D47,

          D43)),

    "")

And some suggestions for other formulas:

Formula:

D41: =WEEKDAY(D19,17) -> This makes the Days table in the Rules sheet obsolete

D44: =IF(DAY(D19)<=5,MONTH(D19)-1,MONTH(D19)) -> This reduces the calculation chain

D46: =DAY(EOMONTH(D19,0)) -> This makes the Month Length table in the Rules sheet obsolete

D47: =D19-WEEKDAY(D19,17)+1 -> This reduces the calculation chain

D48: =D19-(D19-WEEKDAY(D19,17)+1)+1 -> This reduces the calculation chain and (indirectly) makes the Days table obsolete

D49: =EOMONTH(D19,0)-D19+1 -> This reduces the calculation chain

D54: =EOMONTH(D19,-1)+1

D55: =EOMONTH(D19,0) -> This formula is designed for getting the end of a month

D58: =D19-WEEKDAY(D19,17)+7 -> This reduces the calculation chain

D60: =D19 (with cell formatted as "Which is a "dddd) -> This makes that you can still calculate with D60

D61: =D19+6 (with cell formatted as "Which is a "dddd) -> This makes that you can still calculate with D61

D63:  =COUNTIF(D31:AN31,"ok") -> Just a gift 

D64: =IF(COUNTIFS(D31:AN31,"<>"&"ok",D31:AN31,"<>"&"enter a value")=0,"No issues","Issues exist") -> Just a gift 

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.