Forum Discussion

Copper Contributor

Mar 04, 2020

WEEKDAY formula

Hi, I'm using a WEEKDAY formula to populate days of the week relative to the dates of the month. When I copy the formula to the next cell, the values are preserved and the day index remains 1 con...

excel

obendor

Copper Contributor

Mar 08, 2020

SergeiBaklan , Any chance you have a different idea?

SergeiBaklan

Diamond Contributor

Mar 08, 2020

obendor

As variant

=TEXT(DATE(CalendarYear,4,ROW()-ROW($A$1)),"ddd")

if you start from row #2