I have a tally sheet with field inputs of nurses working days. I need to separate # of week days and of weekend days. The sheet looks like this :
<tbody>
</tbody>
I did some cleaning first: TRIM(SUBSTITUTE(UPPER(C3),"JAN"," "))
I have tried different combinations of
* MID(<source>,FIND(",",<source>+1,2)
* MID(<source>,1,FIND(" ",<source>-1))
And proceed so forth step-by-step, but is there a better way (vba macro?) to get a result of separating the chain of days worked into individual dates and count the number of weekdays and of weekend days:
<tbody>
</tbody>
Thank you for anyone who comes with any idea, even partial ideas and I promise to post my findings for everyone to see. Tallies of this kind are used all over the place.
Alain
Site | Name | Dates in 2013 | |
MUL | MK |
<tbody> </tbody> | |
MUL | PN |
<tbody> </tbody> | |
MUL | RM |
<tbody> </tbody> |
<tbody>
</tbody>
I did some cleaning first: TRIM(SUBSTITUTE(UPPER(C3),"JAN"," "))
I have tried different combinations of
* MID(<source>,FIND(",",<source>+1,2)
* MID(<source>,1,FIND(" ",<source>-1))
And proceed so forth step-by-step, but is there a better way (vba macro?) to get a result of separating the chain of days worked into individual dates and count the number of weekdays and of weekend days:
Site | Name | Dates in 2013 | Weekdays | Weekend Days |
MUL | MK | 05,12,19,26 Jan, | 4 | |
MUL | PN | 21,26,27 Jan, | 1 | 2 |
MUL | RM | 29 Jan, | 1 |
<tbody>
</tbody>
Thank you for anyone who comes with any idea, even partial ideas and I promise to post my findings for everyone to see. Tallies of this kind are used all over the place.
Alain