Hello,
I would appreciate your advice on how to make "WeekdayName" VBA function work with European date format (dd/mm/yyyy).
Currently, I have the below line in my code which is returning an incorrect weekday name. The weekday name is based on mm/dd/yyyy format which seem to be the default for "WeekdayName" function.
Thanks in advance,
Please Login or Register to view this content.
K
Last edited by jeffreybrown; 03-30-2019 at 10:40 AM. Reason: Please use code tags!
In my case it works correctly (on the date in the format "dd/mm/yyyy" and "dd-mm-yyyy", i.e. "29-03-2019" in 'D1' cell):
Works correctly ("Saturday") with both "0" and "2" parameters (firstdayofweek)Please Login or Register to view this content.
, but it doesn't work correctly this:
returning the day at 1 earlier ("Friday") than it should.Please Login or Register to view this content.
Maybe...
Please Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
@porucha vevrku,
Thanks for your suggestions. However, aren't you using basically the same code as mine? Interestingly that it works for you.
@WasWodge,
Thanks for the suggestion, but unfortunately, it doesn't fix the problem.
Note that unlike VBA's "WeekdayName", Excel's TEXT function returns the correct day:
Example.jpg
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thank you, @shg. The "dddd" formatting is doing the job!
You're welcome.
Deleted as should have been looking at column G in the latest image.
Last edited by WasWodge; 03-30-2019 at 02:42 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks