I am having an issue with my weekday function. The logic i am using is below but its not calculating the right number for the day of the week. For example I have the date 4/28/21 which should be a wednesday. The logic below should show that date as a 3 or 4. However, it calculates it as 7. which is a Saturday. I have multiple columns that are having the same issue. What can i do to make sure that both columns below calculate the same day number?