Amazing tutorial! I have learnt quite alot from this. However would like to ask if there is another way we can change the month instead of hard coding
@MicrosoftOfficeTutorials
3 жыл бұрын
Hi Jon I would suggest to understand the logic behind formula i used for this, that will make it easy for you to understand formula. Moreover this formula will help you not in this attendance sheet only but to solve many other problems in excel
@waseembralvipoetry2748
Жыл бұрын
i have a question sir when i fill present in 1 jan 2023 it will automatically fill in also other month how to solve this problem
@tarekh131
3 жыл бұрын
Thanks I have a question please , if i want to select 2 days off , how i can use the ( new rule ) to fill it one time
@MicrosoftOfficeTutorials
3 жыл бұрын
Use conditional formatting same as used for 1 day off and write name of 2nd day off in ace of SUN, for P(present) add one more IF Function with name of 2nd day off Pleass let me know if it is clear or you need further assistance in this
@goodnewstotheworld9135
3 жыл бұрын
@@MicrosoftOfficeTutorials I would like to add three days off from WED to THU & FRI instead of SUN. Can you please show the formula and modification for this?
@milo931
3 жыл бұрын
@@MicrosoftOfficeTutorials Could you please add here the formula if we need sat and sun day off at the present area.conditional format area is clear.but here im confused.
Пікірлер: 10