LeLapinLeStrange
New Member
- Joined
- Dec 3, 2016
- Messages
- 2
Hello,
I have been looking through the threads and I am unable to find a formula that fits the following scenario:
I want to be able to put a year in F4 and a month (1-12) in F6 and payroll dates to populate automatically in fields F8, F9, and F10. If there are only 2 dates in the month, I would like F10 to populate with a "θ" or something equivalent. I have been trying to calcualte it by starting with the first payroll date of 2016 which was January 7th, 2016. I have played around with numbers and equations and am kind of going around in circles. I have looked on other forums and none really fit what I'm trying to accomplish. Attached is a sample of what I am attempting. Any and all direction would be great! Thanks.
<tbody>
</tbody>
I have been looking through the threads and I am unable to find a formula that fits the following scenario:
I want to be able to put a year in F4 and a month (1-12) in F6 and payroll dates to populate automatically in fields F8, F9, and F10. If there are only 2 dates in the month, I would like F10 to populate with a "θ" or something equivalent. I have been trying to calcualte it by starting with the first payroll date of 2016 which was January 7th, 2016. I have played around with numbers and equations and am kind of going around in circles. I have looked on other forums and none really fit what I'm trying to accomplish. Attached is a sample of what I am attempting. Any and all direction would be great! Thanks.
Pay Period |
Year |
F4 |
Month |
F6 |
Pay Dates |
F8 |
F9 |
F10 |
<tbody>
</tbody>