Easy Excel Daily Planner freetricksall . Daily tip excel today time planner and his effects . we create time planner first 6:00:00 AM this Wake Up Time Goal    we use ( If , And ) function on this excel sheet easy and simple formula. first select row and colon colors give heading red color and text color is white next give some space and make a time colon with colors some dark cell some light colors Select a next color yellow to task and front of the time cell light and white colors type in time cell 6:00 AM
or =A6+$O$6 you select these different method mean if you select another cell to inter time and just include cell name than you type this style. =IF(J3="Yes","Great job! Off to a great start!",IF(J3="Early","You are really planning to conquer the world or you just can't sleep :)",IF(J3="A little late","A little late? Doesn't matter. You are still awesome!","Oh, feeling sleepy? Enjoy your day even so!")))  
Next you task formula     =IF(COUNTIF($C$6:$F$24,"Partly")=0,"",COUNTIF($C$6:$F$24,"Partly"))

Complete task than use this formula      =IF(COUNTIF($C$6:$F$24,"Yes")=0,"",COUNTIF($C$6:$F$24,"Yes"))

Post a Comment

Popular Posts

 
Top