Align Bi-weekly Expenses to Monthly

[gatorgrad]

I am looking for a way to analyze on a monthly basis the output vs cost (in bi-weekly salaries) from a warehouse. How can I accurately adjust for the two months each year that include 3 pay periods?

[way2020]

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you
have removed any private information, remember this is a public forum and so available to anyone.
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

Just before posting, scroll down to GO ADVANCED, click, and then scroll
down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[Croweater]

In cell A1 put your first pay date of the year
In cell A2 =A1+14 and drag down to A27
In Cell B1 :B12 put the month and year (drag down from B1)
In cell C1 =COUNTIF($A$1:$A$27,">" & EOMONTH(B1,-1))-COUNTIF($A$1:$A$27,">" &EOMONTH(B1,0)) and drag down for each month