Provide functions that work better with dates.
For example, have a function that actually gives the day of the week spelled out instead of a number.
Fraser R commented
I am trying to calculate number of weeks between two dates. I've used networking days and that works just fine. I then tried taking that number of days and tried to divide it with 5 to give me working weeks, that does not work. Any Suggestions Please.
Kenneth Barber commented
Suppose that our date is TODAY(). You would use TEXT(TODAY(),"dddd").
If you are wondering what's with the "dddd", it's because TEXT handles many text formats. It's not specific to giving weekday names.