0

I am using the following formula to calculate the day of week based off of the Start Date column:

=TEXT(WEEKDAY([Start Date]),"dddd")

The problem is that when I create the event on the calendar view I'm getting the day that ends up being displayed in list view is 1 day prior.

Does anyone have any thoughts on why this is occurring?

If I go into the list view and edit the date though it will recalculate to the correct day of week.

1

Try using your formula like below:

=TEXT(WEEKDAY([Start Date]+1),"dddd")

official documentation:

  1. WEEKDAY function.
  • This works but it makes the list unstable. If a user accidentally goes into list view and edits the dates it will then calculate incorrectly and be ahead one day instead of behind. – Joe Cambareri Dec 27 '19 at 14:23
  • Have you tried editing the list item? – Ganesh Sanap Dec 27 '19 at 15:07
  • Yes, when I edit the list item using the formula you provided the day turns to Friday in the example above. – Joe Cambareri Dec 27 '19 at 15:19
0

Try using the below formula,

=TEXT([Start Date],"dddd")

I just tried this function and it gives me the correct weekday.

0

What is the return type of your calculated column? I tested with your formula and calendar view does not have any issue. You can try the same formula with a new column and other lists to see if the issue persists.

  • The return type is 'single line text' – Joe Cambareri Dec 30 '19 at 1:50
  • @JoeCambareri Does the formula works correctly in a new list? – jerry_MSFT Dec 30 '19 at 3:05
  • No, it doesn’t work correctly in a new list or in a different column on the same list. – Joe Cambareri Dec 30 '19 at 3:33
  • 1
    @JoeCambareri, if the issue is site-level or tenant level, you may open a service request to have a check on your tenant. – jerry_MSFT Dec 30 '19 at 8:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.