Download workbook:
Learn how to:
1. Create a column that contains First Day Of Week for each date in the column using the WEEKDAY Function
2. See the Excel 2010 WEEKDAY Functions new arguments for starting the week on Friday
Nguồn: https://sylvaniachristian.com/
Xem thêm bài viết: https://sylvaniachristian.com/category/cong-nghe

i need a week ending formula, as weekending is Sun but it should consider the duration from Monday to Sun in the same week.
Eg: we should get the weekending as 17th Dec, 2017, duration starting from 11th of Dec ,17- to 17th, Dec,17.
You are my savior! this trick really works to me! thanks a lot !
You are welcome!
Thanks Mike i learn allot from you and Bill.
@Dolly3130 , you are welcome!
Just found your site. Wonderful for even a seasoned excel user. Thank you for sharing your expertise.
@krn14242 , you are welcome!
Thanks Mike