Forum Discussion

obendor's avatar
obendor
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 consistently. How can I have the formula change the days' index automatically?

 

=TEXT(WEEKDAY(DATE(CalendarYear,4,1),1),"aaa")

 

Tnx

excel

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 04, 2020

    obendor 

    I'd suggest to put in first cell (let say A1) just the date 2020-04-01 (or what is you default date format), apply to it custom format ddd and in next cell just use =A1+1. Drag it down.

Resources