+ 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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,409

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. [SOLVED] 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