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.

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.`

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

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.

Users Browsing this Thread

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

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1