+ Reply to Thread
Results 1 to 2 of 2

Personal Budget with auto-populating bills based on due date.

  1. #1
    Registered User
    Join Date
    03-20-2021
    Location
    nova scotia, canada
    MS-Off Ver
    16
    Posts
    1

    Personal Budget with auto-populating bills based on due date.

    Hey All,
    I am trying to build a budget that has a sheet listing all the bills with their monthly due date. Then another sheet listing the paydays. Under each payday, I want the bill to show up based on its due date.

    So for example, Pay day is the 12th. Bill 1, Bill 2 and Bill 3 come out on or after the 12th but before the next pay on the 19th. So those 3 bills show up under the 12th payday column.

    Is this doable without macros?

    Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,215

    Re: Personal Budget with auto-populating bills based on due date.

    Welcome to the forum.

    Yes, probably.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. How to display multiple bills from a budget until the next pay date
    By skyep2058 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-14-2020, 02:34 PM
  2. Auto Populating Date based on dropdown selection
    By johnrochie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2020, 10:14 AM
  3. [SOLVED] Personal Budget
    By billgyrotech in forum Excel General
    Replies: 3
    Last Post: 01-30-2015, 07:56 AM
  4. Need Budget Template for Bills, expenses, credit card balances wh.
    By Allicia in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-01-2014, 01:24 PM
  5. Bi-weekly budget - formula for entering bills by due date
    By Hstclair05 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 02-01-2013, 06:39 PM
  6. How to get date to auto change for bills
    By skullzy in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-29-2009, 04:55 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