+ Reply to Thread
Results 1 to 2 of 2

Get data if payment date > number of days in this month

  1. #1
    Registered User
    Join Date
    04-16-2021
    Location
    England
    MS-Off Ver
    2016
    Posts
    1

    Get data if payment date > number of days in this month

    Hi,

    I'm trying to make a direct debit forecasting tool that auto plots the payment amount at the relevant date for the relevant amount given the information on the direct debits from a table. The formula I have so far is:
    Please Login or Register  to view this content.
    The first part of the formula is checking that the date in question is equal to the payment date from the table, the second part is making sure that the date in question is less than the payment end date. Its then looking up the value if the conditions are met.

    What I need is the ability to make sure that any payments are posted for the month regardless of the length of the month. I.e. My columns are the days of the week for each day of each month all the way to 2023. But if a payment date is 31st and there are only 30 days in the month, it wont post the payment into the cell.

    How can I add this functionality to my formula? I have a helper row (5:5) that puts the last day of the month in the column on the last day (i.e. it will put 28 on feb 28 so that is identifying when the last day of the month is, i just need to know how to compare the payment date to that value in the formula I already have.

    Thanks in advance for any help.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,689

    Re: Get data if payment date > number of days in this month

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Counting the number of days in each month across two date ranges
    By ScottDAndersen in forum Excel General
    Replies: 3
    Last Post: 03-28-2019, 07:05 PM
  2. Replies: 16
    Last Post: 08-22-2017, 11:20 AM
  3. Replies: 14
    Last Post: 04-06-2015, 09:19 PM
  4. [SOLVED] Number of days in month from a given date
    By BrownBoy in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-17-2014, 01:58 PM
  5. Replies: 2
    Last Post: 11-09-2012, 12:01 PM
  6. Replies: 4
    Last Post: 03-01-2012, 04:27 PM
  7. Replies: 3
    Last Post: 02-05-2012, 01:32 PM

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