Formula to spill Days and dates

[Jay325]

Hello

I was wondering if it is possible to spill data (days/dates) in ranges "A5:B11" & "A15:B21" from one formula living in B5. It would take the start date from whatever is entered in B1.

Thank you

Jay

[AliGW]

Not in ONE, no, because there is manual data in the way, but in TWO:

=SEQUENCE(7,,B1,1)

and:

=SEQUENCE(7,,B1+7,1)

[Jay325]

Thank you ALiGW!. I was wondering if it is possible to pull days of the week (A5:A11 & A15:A21) from the dates by adding to the formulas in B5 and B15.

[Gregb11]

Since the day of the week is just the presentation (same data), you could use the same formula Ali gave you in column A (in other words, in A5 enter:
=SEQUENCE(7,,$B$1,1)
(you could also just put this in A5)
=B5#

then format the cell by choosing "Custom" and in the "Type" field, enter ddd

see attached.

[Rick Rothstein]

If you remove the values in B5:B21, but leave the formatting, then this single formula in cell B5 should do what you asked for...

Please Login or Register  to view this content.

[Jay325]

Thank you for showing me that Gregb11.

[Jay325]

Thank you for showing me that Rick take care.

[Jay325]

Hi Rick is there a way to add to your formula in B5, to show days of the week in A5:A11 & A15:A21?

[Rick Rothstein]

No, you cannot have a formula in cell B5 that puts values in Column A (at least I do not know a way to do that); however, you can clear the contents in A5:B21 (but leave the formatting as is) and put this formula in cell A5 to fill out your table...

Please Login or Register  to view this content.

BUT, the formatting of the text "Week#2" (Center Across Selection) will not be retained. So if you wish to do this with a single formula (which I really do not see a need for... there is nothing wrong with two separate formulas, one for each week), you will have to put the text "Week#1" and "Week#2" in Column A.

[Jay325]

Thank you Rick