Forum Discussion
formulas
I need to write a formula that takes any date in November 2017 and returns the day of the week using MOD to get an integer between 0 and 6. I'm not sure how to go about this still.
2 Replies
- This looks like a test question if you have to use MOD
Hi Morgan,
Why don't you use WEEKDAY function? https://support.office.com/en-gb/article/WEEKDAY-function-60e44483-2ed1-439f-8bd0-e404c190949a
