CF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have columns with hundreds of dates.
I need a Conditional Formatting formula to text color all dates, let's say
in August.
I know how is done, just need the FORMULA, if somebody is so kind.
Appreciatte it. Thanks.
 
=TEXT(A1,"mmmm")="August")

or

=MONTH(A1)=8

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks for the formula. Bob Phillips you missed a parentesis in the first
formula, but I figured out. Thanks. Do you have one that will include the
month and the year too ?
Thank you also Shah Shailesh
 
Try...

=AND(TEXT(A1,"mmmm")="August",YEAR(A1)=2007)

or

=AND(MONTH(A1)=8,YEAR(A1)=2007)

Rick
 
Try this:

=TEXT(A1,"mm/yy")="08/07"

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Thanks for the formula. Bob Phillips you missed a parentesis in the first
formula, but I figured out. Thanks. Do you have one that will include the
month and the year too ?
Thank you also Shah Shailesh
 
Actually, I added one at the end.

=TEXT(A1,"yyyymm")="200708"

or

=TEXT(A1,"yyyymmm")="2007Aug"

or variations on these

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thank you Shah Shailesh, RagDyeR, Rick Rothstein and Bob Phillips for your
helpfull answers. Someone once said :
" Giving gives more satisfaction than receiving "
 
Back
Top