How to Use the WEEKDAY Function in Excel

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 ►


Xem thêm bài viết khác:

  • Great Video- if I had week day rate = 20, Saturday- 30 and Sunday- 40. What would the formula be please. Thanks

    Jyoti Hingorani June 27, 2020 8:57 pm Reply
  • 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?

    Henry Wu June 27, 2020 8:57 pm Reply
  • Hi Alan.. another good one. Thumbs up!

    Wayne Edmondson June 27, 2020 8:57 pm Reply
  • 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

    SL Terrace June 27, 2020 8:57 pm Reply

    AkaExcel June 27, 2020 8:57 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *