Forum Discussion

Brass Contributor

Oct 12, 2022

Solved

budget worksheet- Friday-Thursday in columns, match date range in rows

I want to be able to have a worksheet that has the date ranges from Friday to Thursday as the column header. These should be sequential across the columns. I may or may not add the year in. Then h...

excel

Formulas and Functions

mtarler
Oct 12, 2022
DayneJake OK I updated the attached using the following:
=IF(ISNUMBER(MATCH($A3,DAY(SEQUENCE(7,,C$1)),0)),$B3,"")
which creates a sequence of 7 days starting on the header day and checks if the "due" day is in that set.

DayneJake

Brass Contributor

Oct 12, 2022

Thanks. I think with some of your suggestions I can get what I need.
Yes, the Due is the date of the month it is due, so 3 or 10 means due the 3rd of every month or the 10th, respectively.
I will try some things and if need help ask more, or post what I got to work out.

mtarler

Silver Contributor

Oct 12, 2022

DayneJake OK I updated the attached using the following:

=IF(ISNUMBER(MATCH($A3,DAY(SEQUENCE(7,,C$1)),0)),$B3,"")

which creates a sequence of 7 days starting on the header day and checks if the "due" day is in that set.