calculate pay checks per month, to get monthly income value for that month.

**tladd** · 11-19-2012, 07:32 PM

i get paid every 14 days so sometimes i get paid three times in a month. I would like to be able to figure out which months this occurs on, possible even auto load it if its in that month into monthly income. So far i input first pay day of the year then did a simple +14 but feel free to educate me if there is a smarter option.

note: if i ignorantly continued with what i have i was going to try to count the number of times a month occurred then get current month check it and multiply pay.... ahhh i know its alot.

I am new here and it seemed like there was some solid advice so please excuse any noobish errors.

i noticed it was common to give attachment as example mine is in office 2010

Thanks!

**TMS** · 11-19-2012, 07:56 PM

You could do something like:

=SUMPRODUCT(--(MONTH($C$3:$C$30)=1))*50 for January but you need to lose today's date from column C.

For all the months, you could use:

=SUMPRODUCT(--(MONTH($C$3:$C$30)=ROW(A1)))*50 ... and drag down

Regards, TMS

**tladd** · 11-19-2012, 08:09 PM

hmm i don't understand what that does tried it anyway but didn't give me the number of occurrences of the given month. The *50 confuses me also.

**TMS** · 11-19-2012, 10:02 PM

The 50 was what I thought you had down as fortnightly pay. Take it out if you just want to count paydays.

Regards, TMS

**tladd** · 11-20-2012, 07:56 PM

Thanks this resolved my issues and got me on the path of figuring the rest out! I appreciate it! is there a way i can mark this as resolved or answered.

**TMS** · 11-20-2012, 09:51 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save