How to auto-fill day column from date without dragging in google sheets?-CodePudding

Home > OS > How to auto-fill day column from date without dragging in google sheets?

How to auto-fill day column from date without dragging in google sheets?

Time：12-01

In google sheets, I have two columns, date and day, when date is entered i want day to be filled automatically, How do we do that ?

CodePudding user response：

Assuming the dates are in A2:A, put this formula in B2:

=ArrayFormula(IF(A2:A="",,DAY(A2:A)))

CodePudding user response：

Use