Populate Dates and Data With Criteria

[kumara_faith]

Hi,

I have the following table:

Day Expense.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Mon	Food	Lunch	8			Start Date	10/7/2024		10/7/2024	Mon	Food	Lunch	8
2	Mon	Food	Dinner	8			Holiday	10/9/2024		10/7/2024	Mon	Food	Dinner	8
3	Mon	Altar	Flower	15				10/10/2024		10/7/2024	Mon	Altar	Flower	15
4	Mon	Food	Bread	3.5						10/7/2024	Mon	Food	Bread	3.5
5	Tue	Food	Lunch	8						10/8/2024	Tue	Food	Lunch	8
6	Tue	Food	Dinner	8						10/8/2024	Tue	Food	Dinner	8
7	Tue	Automobile	Toll	1.72						10/8/2024	Tue	Automobile	Toll	1.72
8	Tue	Automobile	Toll	10.75						10/8/2024	Tue	Automobile	Toll	10.75
9	Wed	Food	Lunch	8						10/11/2024	Fri	Automobile	Toll	1.72
10	Wed	Food	Dinner	8						10/11/2024	Fri	Automobile	Toll	10.75
11	Wed	Automobile	Toll	1.72						10/11/2024	Fri	Food	Lunch	8
12	Wed	Automobile	Toll	10.75						10/12/2024	Sat	Automobile	Fuel	60
13	Thu	Food	Lunch	8						10/14/2024	Sun	Food	Drink	10
14	Thu	Food	Dinner	8
15	Thu	Automobile	Toll	1.72
16	Thu	Automobile	Toll	10.75
17	Fri	Automobile	Toll	1.72
18	Fri	Automobile	Toll	10.75
19	Fri	Food	Lunch	8
20	Sat	Automobile	Fuel	60
21	Sun	Food	Drink	10
Sheet1

1) Column A to D shows the fixed expenses that will be incurred every week.
2) Cell H1 shows the start date for the week. This may or may not be a Monday
3) Cell H2 to H6 will show the holidays in the week.

I am trying to populate the expenses for the day based on the start date and exclude the holidays. The correct results are in column J to N. Is there a way to use a formula for this ?

 

[kumara_faith]

Hi Alex,

Is there a way to populate the dates as well as per the original post in the formula result?

 

[Alex Blakenburg]

That is likely to be a totally different formula, it might be better to create a new thread for that. I am logging off for the night.