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
Blocked Profile - Jun 6, 2013 at 09:25 AM
Related:
- Formula for change of dates daily for one month of working days
- Change name of lg tv - Guide
- Skype last seen days ago - Guide
- How to change number of best friends on snapchat - Guide
- Facebook date of birth change - Guide
- Change computer name cmd - Guide
3 responses
http://www.s-splumbing.com/outward/weekdaytest.xlsx
Here is a working example.
If it works then click answered please.
Here is a working example.
If it works then click answered please.
=IF(WEEKDAY(E9)=1,"X",IF(WEEKDAY(E9)=7,"X",TEXT(WEEKDAY(E9),"dddd")))
this had better not be a school project.
this had better not be a school project.
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.
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
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
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
thirsty
Posts
3
Registration date
Tuesday June 4, 2013
Status
Member
Last seen
June 4, 2013
Jun 4, 2013 at 08:46 PM
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"
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"
Jun 5, 2013 at 05:02 PM
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
Jun 6, 2013 at 09:25 AM
CONTENTS OF B5 =IF(WEEKDAY(A5)=1,"X",IF(WEEKDAY(A5)=7,"X",TEXT(WEEKDAY(A5),"dddd")))
Contents of B5 would print out "WEDNESDAY"