Date format

Question

I want to change the format of the column header to be the actual date in format MM/DD/YYYY. A user in another country set everything up in format DD/MM/YY and I want to change it.

Gaurav Kumar · Answer

I think this approach can work here.

Step 1: Find the year from the week number(W/c 24 Sep 23) using Year function e.g., 2023

Step 2: Find the first day of the year e.g., WEEKDAY(DATE(Year, 1, 1))

Step 3: Find the first date of the week in Current Period Week line item using this formula:

DATE(Year, 1, 1) + 7 * (Week no - 1) - First day of the year

Let me know if it works @basch

basch · Answer

@GauravKumar Yes that is correct

Gaurav Kumar · Answer

Hi @basch but the highlighted item(Current Period Week) is a week formatted line item and you want to see in date format? Is that correct? for W/c 24 Sep 23 you wanna see 09/24/2023?