+ 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 Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    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.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  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. [SOLVED] 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. [SOLVED] transfer cell $ amount to other sheet month-to-month without overc
    By Colin2u in forum Excel General
    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