Determine if a date is on a Weekday or Weekend in Excel
HTML-код
- Опубликовано: 10 июн 2020
- In this Excel tutorial, we are going to learn how to write a formula to determine if a date falls on a weekday or a weekend.
Buy Me a Coffee? Your support is much appreciated!
PayPal Me: www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn
More tutorial videos on my website
LearnDataAnalysis.org
Considering support my channel through shopping on Amazon
amzn.to/2JkGeMD
Want to be more productive? Check out the the gear (Amazon affiliate links) I use when I am working.
Lenovo ThinkPad X1 Extreme 2nd Gen (4K): amzn.to/2QT1CNk
ASUS Designo Curve MX38VC 37.5" Monitor: amzn.to/39rFSOQ
Logitech MX Master 3 Advanced (My primary mouse): amzn.to/2WSumK2
Logitech MX Anywhere 2S (When traveling): amzn.to/2WTdKl5
Logitech Craft Advanced Wireless Keyboard: amzn.to/2QUjAz1
VAVA USB C Hub, 8-in-1 USB C Adapter : amzn.to/3dFim4g
Theralite Aura Bright Light Therapy Lamp: amzn.to/2UIp5lv
#Excel #ExcelTutorial
How would you do it if I wanted to denote a weekend as 1 and a weekday as 0 instead of true or false?
Add +0 will convert the output to integer.