+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    USA
    MS-Off Ver
    15.23
    Posts
    3

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

    Any advice?

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,752

    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: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by mehmetcik; 04-24-2017 at 03:24 PM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Registered User
    Join Date
    04-24-2017
    Location
    USA
    MS-Off Ver
    15.23
    Posts
    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. #4
    Registered User
    Join Date
    04-24-2017
    Location
    USA
    MS-Off Ver
    15.23
    Posts
    3

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

    That worked mehmetcik. Your assistance is much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-15-2016, 10:12 AM
  2. [SOLVED] Formula for amount on previous month based on current month
    By Yu Marquez in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-21-2014, 12:42 AM
  3. [SOLVED] Get the amount of working days in a month using the computer date
    By Drunknmonkie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-06-2013, 08:10 PM
  4. Replies: 2
    Last Post: 03-22-2013, 02:20 PM
  5. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  6. Pls Help on from date tranfer amount to month
    By Tiya in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2006, 12:40 PM
  7. Replies: 1
    Last Post: 07-27-2005, 09:36 PM

Tags for this Thread

Bookmarks

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