If this is a repeat question, my apologies.
I am creating a worksheet that will calculate gross payroll. We are paid biweekly and there is an amount that only shows up on the first check of the month.
What would be the wording for a formula that will look at the check date and calculate if it is it the first check of the month, then enter a set amount into a cell if it is.
Any advice?
Bookmarks