Thread
: [Solved]
Format in a formula month and numbers
View Single Post
02-27-2019, 09:36 PM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,097
With date in A1
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Format the cell with the formula: yyyy-mm-"00"d
xor
View Public Profile
Find all posts by xor