Formula for change of dates daily for one month of working days
Closed
thirsty
Posts
3
Registration date
Tuesday 4 June 2013
Status
Member
Last seen
4 June 2013
-
4 Jun 2013 à 17:56
Blocked Profile - 6 Jun 2013 à 09:25
Blocked Profile - 6 Jun 2013 à 09:25
Related:
- Formula for change of dates daily for one month of working days
- Change name of lg tv - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Facebook date of birth change - Guide
- If formula for dates - Guide
- How to change number of best friends on snapchat - 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 4 June 2013
Status
Member
Last seen
4 June 2013
4 Jun 2013 à 20:18
4 Jun 2013 à 20:18
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 4 June 2013
Status
Member
Last seen
4 June 2013
4 Jun 2013 à 20:46
4 Jun 2013 à 20:46
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"
5 Jun 2013 à 17:02
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
6 Jun 2013 à 09:25
CONTENTS OF B5 =IF(WEEKDAY(A5)=1,"X",IF(WEEKDAY(A5)=7,"X",TEXT(WEEKDAY(A5),"dddd")))
Contents of B5 would print out "WEDNESDAY"