# Formula that will put an amount in a cell if before a date every month

1. ## Formula that will put an amount in a cell if before a date every month

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.   Register To Reply

2. ## Re: Formula that will put an amount in a cell if before a date every month

If it is the first Cheque of the month then its date will be less than 15.

Formula:  `Please Login or Register  to view this content.`  Register To Reply

3. ## Re: Formula that will put an amount in a cell if before a date every month

Thank you so much. I will try that   Register To Reply

4. ## Re: Formula that will put an amount in a cell if before a date every month

That worked mehmetcik. Your assistance is much appreciated.   Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 