1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Pull bills between 2 dates

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.

https://preview.redd.it/gperwbhnf3ng1.png?width=813&format=png&auto=webp&s=c4fc09414af160d252597c46d9308b60dc54ed61

Example of desired outcome between dates 1/15 and 2/6:

https://preview.redd.it/1zql79wwh3ng1.png?width=247&format=png&auto=webp&s=22cbf68e5bc48b52c7230931e66d8b331f8e884a

submitted by /u/IAmCabbageLord
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#Excel alternatives
#pull bills
#due date
#between two dates
#Excel
#monthly bills
#price
#date of the month
#sample bills
#financial management
#due bills
#date range
#desired outcome