Quote:
Originally Posted by xor
With date in A1
=DATE(YEAR(A1),MONTH(A1),DAY(A1))
Format the cell with the formula: yyyy-mm-"00"d
|
Thank you Xor for the immediate reply. The formula should return the year and month from A1, after the month is a serial number taken from B1, like:
A1: January 18, 2019 (named range "Date")
B1: 1 (named range "ObR")
C1 where the formula is: 2019-01-001