Excel Formula to calculate wages for certain months - with some tricky variables

I have a curly one. Screenshot attached. I need to calculate each months wages for an individual staff member (row 8) based on start and/or finish dates or, if blank, start & end of financial year (J8 & K8). Also based on total in columns Z and AA depending on which month is being calculated. Also, to make it even trickier, to calculate this amount based on the number of pay fortnights in each month as displayed in row 3 of each month.

A picture is not much use to us, especially as it is difficult to read on this forum - it would be better if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Thanks for the suggestion Pete_UK. Sorry been so long getting back on forum - been a hectic week.
Hoping the attached can give you what you need to help me out.
Thanks in advance

Originally Posted by JeteMc

I am guessing that you want a single formula to populate AB6:AM7
If so try: =IF(OR(AND($J6>0,$J6>AB$5),AND($K6>0,$K6<AB$2)),"",IF(AB$2<$Z$2,$Z6/$Z$4,$AA6/$AA$4)*14*AB$3)
Let us know if you have any questions.

You are brilliant JeteMc. Thank you so much!!!!