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

3 Answers 3

1

Try using your formula like below:

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

official documentation:

  1. WEEKDAY function.
3
  • 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. Dec 27, 2019 at 14:23
  • Have you tried editing the list item? Dec 27, 2019 at 15:07
  • Yes, when I edit the list item using the formula you provided the day turns to Friday in the example above. Dec 27, 2019 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.

4
  • The return type is 'single line text' Dec 30, 2019 at 1:50
  • @JoeCambareri Does the formula works correctly in a new list?
    – Jerry_MSFT
    Dec 30, 2019 at 3:05
  • No, it doesn’t work correctly in a new list or in a different column on the same list. Dec 30, 2019 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, 2019 at 8:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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