Forum Discussion
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...
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.