# Formula for change of dates daily for one month of working days

Closed
thirsty Posts 3 Registration date Tuesday June 4, 2013 Status Member Last seen June 4, 2013 - Jun 4, 2013 at 05:56 PM
Blocked Profile - Jun 6, 2013 at 09:25 AM
Hello.
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.
Cheers
Ross
PS I know I can add a day by a formula, say =+A5+1.
I need to drop weekends
Related:

## 3 responses

Blocked Profile
Jun 5, 2013 at 10:37 AM
http://www.s-splumbing.com/outward/weekdaytest.xlsx

Here is a working example.

Yes that is great.
But if I have a spreadsheet with the dates in the column A rows 5-25 with no weekends already, they are for Jan 1022 at the moment where does the formula get entered. In cell A5 through 25?
Ross
Blocked Profile
Jun 6, 2013 at 09:25 AM
NO, the date stil needs to be in column A. The Weekday name formula would be inserted into any blank cell that tests the date. so if you wished to test a5 for weekdayname then formula would be....
CONTENTS OF B5 =IF(WEEKDAY(A5)=1,"X",IF(WEEKDAY(A5)=7,"X",TEXT(WEEKDAY(A5),"dddd")))
Contents of B5 would print out "WEDNESDAY"
Blocked Profile
Jun 4, 2013 at 07:08 PM
=IF(WEEKDAY(E9)=1,"X",IF(WEEKDAY(E9)=7,"X",TEXT(WEEKDAY(E9),"dddd")))

this had better not be a school project.
Blocked Profile
Jun 4, 2013 at 08:24 PM
in the above example...cell e9 would contain the value you wish to test. so in my example, e9 would contain something like 1/3/2012, e10 would contain 1/4/2012 and so on....

once you have acheived the result, then drag the small "+" in the bottom corner down the colum. the formula will follow according to the row.
thirsty Posts 3 Registration date Tuesday June 4, 2013 Status Member Last seen June 4, 2013
Jun 4, 2013 at 08:18 PM
Thanks ac3mark.
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?
Regards
Ross
Blocked Profile
Jun 4, 2013 at 08:25 PM
see above..click solved if I solved it Thank you. You can always come and ask! I am happy to help as long as it is not for school!
thirsty Posts 3 Registration date Tuesday June 4, 2013 Status Member Last seen June 4, 2013
Jun 4, 2013 at 08:46 PM
I wish to have cells A5 to A 25 to show working days of the month Jun 2013 without having to change each cell each month.
I pasted your formula into E9 in a blank book. Should each cell below E9 have a date in it?
Excel message says "the formula you typed has an error"
Blocked Profile
Jun 5, 2013 at 10:13 AM
well "shorturl" keeps deleting my url so i am going to another dumping ground!

http://www.s-splumbing.com/outward/weekdaytest.xlsx

I have posted a working spreadsheet with the same code in it at the previous address. This file is going to be removed in 24 HOurs due to bandwidth and hosting costs!