Forum Discussion
Today function to show weekdays
Every weekday I create a schedule for the next business day for my field guys. Cell H1 contains the date the schedule is for. Currently that filed has =today()+1 so it always shows tomorrows date. Ev...
You could use WORKDAY:
=WORKDAY(TODAY(),1)
WORKDAY also includes an optional Holidays argument where you could specify days to skip that may not necessarily be weekends.
I'll try that, thank you.
- You're welcome!