Trying to insert certain cells if another cell falls between two dates.

Xavierstram

New Member
Joined
Aug 9, 2019
Messages
1
https://1drv.ms/u/s!AmfNhO-qyFc5iSnpBImBa6_Ndu_U?e=U3dbXq


Screenshot in the link above

I'm trying to create a function so that the bills in the top left will auto-generate into the table for the different weeks. For example if a bill falls between the 1st-10th than i would like them to automatically populate in the Week 1 Section on E17 and go down sequentially. If I have to add a bill on the left than it will auto include into the tables in the appropriate week based off the day the bill is due. and continue all the way for the rest of the table. so week 2 would be between 11-19. week 3 20th-25th etc.

Been numbing my brain trying to figure this out.
 

Forum statistics

Threads
1,082,504
Messages
5,365,962
Members
400,864
Latest member
RobynP51

Some videos you may like

This Week's Hot Topics

Top