Dear all,
I have a file which has a column of date as shown in the attached file I want to add other column to know which day refer to each date.
Any help in that please?
Thanks in advance for your kind support.
Hi @Feras95p ,
if you need the weekday in a "long" form, you can use the formulaDateTimeFormat([Date], '%A')
This will return e.g. "Saturday" or "Monday".
The abbreviated form ("Mon", "Tue") will be the result of:
DateTimeFormat([Date], '%a')
while
DateTimeFormat([Date], '%w')
will retrurn a day number (0 for Sunday, 1 for Monday).
Hope this is helpful.
Best,
Roland
@Feras95p,
I'm sorry, but I don't understand the request. You've got a date of 2016-06-02. What result value are you hoping to see?
Cheers,
Mark
The problem is that there is some missing data so the order of the days will be mixed up.
I want to have output of which day is match every date for example the 2016-06-02 is Thursday.
