Forum Discussion

abutula1988's avatar
abutula1988
Copper Contributor
Sep 12, 2019

Converting Date to Week/Year Format

I have an output from SAP that produces the column in the left and I am looking for a formula that will get it to format like the column on the right, so when I create a pivot table the ww/yyyy forma...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 12, 2019

abutula1988 

From you sample it's not clear how data are formatted in left column. Assuming converted to mm/yyyy dates are not formatted back to text, formula could be

 

=IF(ISTEXT(A1), A1, TEXT(MONTH(A1),"00") & "/" & YEAR(A1))

 

 

Resources