Forum Discussion

DayneJake's avatar
DayneJake
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's avatar
    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's avatar
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's avatar
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. 

Resources