CF for next month/this year
 

I recently got this formula from Dave, thanks :
=text(A1,"yyyymm")=text(today(),"yyyymm")
to use it in conditional formatting and color RED all dates for this month.
Now I need the "contraparte" for another worsheet :
CF to color GREEN all dates for next month, today is October, next month will
be November, Etc. Autoupdating like the above formula does.
THANKS in advance.

CF for next month/this year
 

computexcel wrote:
I recently got this formula from Dave, thanks :
=text(A1,"yyyymm")=text(today(),"yyyymm")
to use it in conditional formatting and color RED all dates for this month.
Now I need the "contraparte" for another worsheet :
CF to color GREEN all dates for next month, today is October, next month will
be November, Etc. Autoupdating like the above formula does.
THANKS in advance.


=DATE(YEAR(A3),MONTH(A3),1)=DATE(YEAR(TODAY()),MON TH(TODAY())+1,1)
^^

Works across year-ends as well.

Adjust the bit above ^^ to make this relative to any number of months.

CF for next month/this year
 

Change today() to DATE(YEAR(Today()),MONTH(Today())+1,1)
--
David Biddulph

"computexcel" wrote in message
...
I recently got this formula from Dave, thanks :
=text(A1,"yyyymm")=text(today(),"yyyymm")
to use it in conditional formatting and color RED all dates for this
month.
Now I need the "contraparte" for another worsheet :
CF to color GREEN all dates for next month, today is October, next month
will
be November, Etc. Autoupdating like the above formula does.
THANKS in advance.

CF for next month/this year
 

.. CF to color GREEN all dates for next month ..

Think you could try:
=TEXT(A1,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(T ODAY())+1,1),"yyyymm")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---

CF for next month/this year
 

Like my cat says "Purrrfect".All three formulas.
Thanks smartin, David and Max
you are very kind.

"Max" wrote:

.. CF to color GREEN all dates for next month ..

Think you could try:
=TEXT(A1,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(T ODAY())+1,1),"yyyymm")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---

CF for next month/this year
 

computexcel wrote:
Like my cat says "Purrrfect".All three formulas.
Thanks smartin, David and Max
you are very kind.

Glad you found an answer.

My cat says "mwraowwwwr?", but he's a little touched.

CF for next month/this year
 

Welcome, thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800, Files:359, Subscribers:56
xdemechanik
---
"computexcel" wrote in message
...
Like my cat says "Purrrfect".All three formulas.
Thanks smartin, David and Max
you are very kind.