Sir I just found your channel and subscribed, I finf it very interesting. However Iwould like to know if you have or can help with a problem. I have a user form that I input dates to show the work period of heavy equipment my goal is using a label or text box display on the form show the difference between the two dates(start Date/End Date) that take into account weekends and holidays. I know the formula for the work sheet (=NETWORKDAYS.INTL(start_date,end_date,[weekend],[holidats])) but need to put the same formula in VBA for the form Can you help?? Thank You.
@eautocad1
2 жыл бұрын
Chek if you can do the below, I have 100's of excel pages with hard page breaks, I want to sum the page, every time when I put the formula for sum for a page and then I copy the sum to other pages where in I need to adjust the range again since number of rows differ in a page, so need a formula so that it identifies the pagebreak and takes the sum below the pagebreak
Пікірлер: 3