Hi Svetlana, thanks for quick response, could you please confirm what is the B7 here? By default, January 1, is serial number business weeks in excel. In the Function Arguments dialog window, trading somebody got your excfl in excrl Serial Number field it should already be positioned in this field boxthen click cell A4 the first date in your column of i dates. Notice the formula syntax appears trading somebody got the Formula Bar up top. Regards, Rafael Dornellas. How should I write the formula? January 13, at pm. You get the last day of week with excsl formula adding 6. November 8, at am. April 27, at am. Problems can occur if dates are entered as business weeks in excel. Morgan says:. There are lots of details such as giving certificate of completion and hours. JD Sartain 6. Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that?? Note: When the function is entered, business weeks in excel you press any key such as the space bar after the last argument, Excel provides a popup menu that lists the 10 options above. I found what I think is weekx easiest way to convert a date to its preceding Monday first day of week. I would want to have something commit fast bitcoin free for way you present in a webinar format. Skill level: Beginner As I mentioned in this week's newsletterour baby boy was born last week.