•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pull bills between 2 dates
Our take
To efficiently manage your bills, you can create a solution that pulls all due dates between two specified dates for each month, using the same due date format. For instance, if you want to retrieve bills due between 2/15 and 3/2, the system will identify and list all relevant bills along with their respective amounts. By referencing the start date in cell A1 and the end date in cell A2, you can streamline your financial tracking and ensure no bill goes unnoticed.
I want to be able to pull all the bills due between two dates for every month, based only on the date of the month. For each month, the due date for bills is the same, so if the dates are 2/15 and 3/2 I want all those bills pulled with the price next to it. I've included a sample of bills, if it helps assume date 1 =A1 and date 2 =A2.
Edit: Original image didn't load, here it is now.
Example of desired outcome between dates 1/15 and 2/6:
[link] [comments]
Read on the original site
Open the publisher's page for the full experience