+ Reply to Thread
Results 1 to 2 of 2

Sum items in column variable relative to date - specifically getting paid on 15th & 30th

  1. #1
    Registered User
    Join Date
    04-29-2019
    Location
    US
    MS-Off Ver
    MAC 11
    Posts
    1

    Sum items in column variable relative to date - specifically getting paid on 15th & 30th

    So I have a client that wants me to create a payment schedule relative to paying on the 15th and 30th for support.

    The problem is that contracts end on variable dates, and different months have 28, 29, 30, and 31 days, all of which I need to be paid for.

    Attached is my spreadsheet, with a RED box for the column in which the formula should be expressed for the column.

    I am probably over-thinking it, but without having to manually do the calculations, I'm sure there is a more elegant way.

    THANK YOU!!!

    Havens
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Sum items in column variable relative to date - specifically getting paid on 15th & 30

    Not really sure how you want this to be calculated. I assumed that you want the payment amount to be everything prior to the current payment date (ie since the last payment date) and including the present payment date.

    If so try this in L21 and drag down

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

+ 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: 8
    Last Post: 02-10-2018, 02:25 AM
  2. how to calculate the 15th business date from starte date
    By sagayastalin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2014, 09:20 AM
  3. [SOLVED] help needed with if then statement containing date between 21st and 30th
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2014, 07:07 AM
  4. Formula for Friday 14 days from start date, but closest to 15th or 30th
    By SiRCYRO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2013, 08:23 PM
  5. Formatting a cell specifically by date
    By rymember in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2011, 09:04 AM
  6. Replies: 1
    Last Post: 06-01-2011, 03:30 AM
  7. [SOLVED] copy every 30th cell in the column into consecutive cells in anoth
    By shortcuts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2005, 03:06 AM

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