davinosky New Member Jul 16, 2012 #1 Hi, How can i extract or highlight the holydays (sundays) from a list of days of month? Ejemp: Columm B July 1 (sunday)(extract or highlight) 2 3 4 5 6 7 8 (sunday)(extract or highlight) 9 ...
Hi, How can i extract or highlight the holydays (sundays) from a list of days of month? Ejemp: Columm B July 1 (sunday)(extract or highlight) 2 3 4 5 6 7 8 (sunday)(extract or highlight) 9 ...
SirJB7 Excel Rōnin Jul 16, 2012 #2 Hi, davinosky! Try using function DIASEM(date[;type]). If type omitted or 1, then function for sundays retrieves a 1; then apply CF. Regards!
Hi, davinosky! Try using function DIASEM(date[;type]). If type omitted or 1, then function for sundays retrieves a 1; then apply CF. Regards!
davinosky New Member Jul 17, 2012 #3 Perfect! I used CF with this funtion =IF(DIASEM(C10,11)=7,TRUE,FALSE). Thank you so much for your help SirJB7 ;-)
Perfect! I used CF with this funtion =IF(DIASEM(C10,11)=7,TRUE,FALSE). Thank you so much for your help SirJB7 ;-)
SirJB7 Excel Rōnin Jul 17, 2012 #4 Hi, davinosky! Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted. Regards!
Hi, davinosky! Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted. Regards!
