How to use the awesome WEEKDAY function in Excel – Real world example.
FREE Instant download – 27 Awesome Excel Hacks –
Excel has many wonderful Excel functions and these include the WEEKDAY function. This function returns a number that identifies the day of the week of a date.
This video tutorial will show a real world example of using the WEEKDAY function. We use it to apply a different pay rate to dates that occur on a Saturday.
Learn over 100 Excel formulas with this online course –
Find more great free tutorials at;
Connect with us!
LinkedIn ►
Facebook ►
Twitter ►
Nguồn: https://buonhangthoitrang.com/
Xem thêm bài viết khác: https://buonhangthoitrang.com/tong-hop/
Great Video- if I had week day rate = 20, Saturday- 30 and Sunday- 40. What would the formula be please. Thanks
What if i ll need include sunday? same rate as saturday. So Mon-Fri $9.00, Sat-Sun $12. What will be the code like?
Hi Alan.. another good one. Thumbs up!
I have Monday to Saturday different amount to display according to the Week day Eg: Monday – 1000 , Tuesday 1200, Wednesday 500, Thursday 800 …. etc how to code in excel using vlookup
IT IS EASY TO UNDERSTAND YOUR VIDEOS!)