I am looking for a formula to add one day to a column of working days in a month. I wish to start the first cell in the column to 1/07/2013 and have the cells in the column add 1 working day in July to the next cell in the column for one month.
PS I know I can add a day by a formula, say =+A5+1.
I need to drop weekends
Formula for change of dates daily for one month of working days
No it is not a school project.
I am just trying to streamline a reporting spreadsheet with my limited knowledge of Excel.
If the column is A and the rows are 5 to 25 for the working days in a month, into which cell do I insert your formula?