in the file i set de color cell yello en green cel by hand.
In the year 2020 the yello
in the file i set de color cell yello en green cel by hand.
In the year 2020 the yello
I have looked - no idea what your logic is, sorry.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I have manual collor the hollidays when a person works half time.
One week he works 3 days the other week he works 2days
I want that de user can select the days in 3 cells the days that he not work. Then collor the cells that he is not at work. In 2020 he have to work 3 days in week 1 en 2 workingdays in week two.
What i alredy found is where here are 53 weeks in a year the 3 days work week are in the oneven weeknr. And by 52 weeks thy are in the even weeks.
What is the formula of function to detect that
3 days work in the even or oneven weeks are so that the 2days work week in the other week and then collerd 2 ore 3 cells for not working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks