Highlight the current or past month dates | Confuse|

[pipsmultan]

Greeting too all...


i am trying to apply Conditional formatting on the dates of joining, i am not successful.

what i am trying to achieve is to Highlight the dates which starts from 1st to 15th of every current month and from 15th to 31th of previous month

any help will be highly appreciated....

plz find the attachment

Date of joining.xlsx

Regards

[Glenn Kennedy]

No... wrong formula - reply deleted

[JohnTopley]

Misread need

[samba_ravi]

Select c12:c100 AND USE BELOW FORMULA IN CONDITIONAL FORMAT
=AND(C12>EOMONTH(TODAY(),-2)+15,C12<EOMONTH(TODAY(),-1)+16)

Please Login or Register  to view this content.

[Glenn Kennedy]

Amended version (a bit overcomplicated), but (I think) correct...

Please Login or Register  to view this content.

[pipsmultan]

Amended version (a bit overcomplicated), but (I think) correct...

Thanks Dear Respected Glenn Kennedy, and all those who spear there valued time to solve my problem... Highly appreciated

Glenn Kennedy: Solution works great like a charm highly appreciated for your time and Help

High Regards

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

[samba_ravi]

Thanks Dear Respected Glenn Kennedy, and all those who spear there valued time to solve my problem... Highly appreciated

Glenn Kennedy: Solution works great like a charm highly appreciated for your time and Help

High Regards

=AND(C12>EOMONTH(TODAY(),-2)+15,C12<EOMONTH(TODAY(),-1)+16)
not working?

[pipsmultan]

=AND(C12>EOMONTH(TODAY(),-2)+15,C12<EOMONTH(TODAY(),-1)+16)
not working?

No it doesn't give the result which required, as formula dont highlight the current month date from "1 to 15" and it only highlight previous month date from 15th to 31 only. but thanks for spearing time for the problem appreciated

[pipsmultan]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

Reputation added and Thread has been marked as sloved Appreciated

Regards