Hi could someone help me please as I am very new to excel. I have a sheet that when I enter a receipt number in column B column A automatically enters today's date and column C automatically enters date of expected completion (+ 5 days of column A) but this includes weekends. How can I get excel to look at only working days I.e. mon-fri ? I will attach the work sheet for you to have a look at.
Bookmarks