Help with formatting Formula using IF statement

HI All,

Hoping someone can advise/help.

This is my first time programming an excel sheet.

I have been given the task for creating a tool for work.
I am trying to create a tool where a manager can input hours worked in someone's last month.

I need to format the following:
IF the Date of Leave =<5 and pay cycle is month, and answered "Yes" to payroll cut off, then plot previous month + first days of following. E.g if colleague is leaving on the 5th October show from 1st Sept to 5 October. If NOT then plot only days needed, e.g. if they are leaving on the 7th October it would only show 1-7th October as Sept was a normal pay period.

If someone can offer some guidance, it would be appreciated! + any tips of learning Excel.

Thanks

HI All,

This is what my spreadsheet looks like at the moment

Thanks so much! But I don't think i explained myself very well!
The hours inputted with be for each day in the month.

Not sure if my first reply is showing:


I am trying to format the following:

IF(AND(D42=<5,D20=”Monthly”, D21=”Yes”),D43-1, D43)

IF(D20=”Weekly”, D19-D47,””)

I am trying to say:

IF(AND(The Leave Date Integer = < 5, AND, Pay Cycle = “Monthly” and answer to payroll cut off is “Yes”), then do month leave integer-1, if not just use month)

IF(Pay Cycle=”Weekly”, do Leave date month- week commencing).

From the above formula I want it to plot the correct days.

Hope this makes sense! It wouldn't let me upload my spread sheet!

Thanks so much!