Formula for change of dates daily for one month of working days [Closed]

Report
Posts
3
Registration date
Tuesday June 4, 2013
Status
Member
Last seen
June 4, 2013
-
 Blocked Profile -
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

3 replies


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

Here is a working example.

If it works then click answered please.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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?
Please forgive my infantile questions.
Ross
Blocked Profile
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"

=IF(WEEKDAY(E9)=1,"X",IF(WEEKDAY(E9)=7,"X",TEXT(WEEKDAY(E9),"dddd")))

this had better not be a school project.
Blocked Profile
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.
Posts
3
Registration date
Tuesday June 4, 2013
Status
Member
Last seen
June 4, 2013

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
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!
Posts
3
Registration date
Tuesday June 4, 2013
Status
Member
Last seen
June 4, 2013

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
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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!