Conditional FormattingEOMONTH Test

[Quantum]

Using Conditional Formatting I was trying to do an end of the mont
check on a preceding cell date entry to control whether or not the cel
after that one would show an orange border (the date entered in the cel
had to be less than or equal to the EOMONTH of that date to give th
subsequent cell an orange border). I could do similar tests with othe
functions (e.g. MONTH, TODAY, Others) but when I tried to use EOMONT
I'd get an error message ("You may not use references to othe
worksheets or workbooks for Conditional Formatting criteria"). I wa
able to do pretty much the same thing by creating another column usin
EOMONTH that gave the end of the month date associated with the dat
entered in the preceding cell column. However, I'd still like to kno
why EOMONTH wouldn't work within my Conditional Format Formula (I jus
started learning about the Excel Conditional Format feature).

MT

 

[Frank Kabel]

Hi
problem is that EOMONTH is part of the analysis Toolpak
Add-in (which is a different workbook). But you can easily
replace EOMONTH. e.g.
=DATE(YEAR(A1),MONTH(A1)+1,0)

gives you the last day of the month for the date value in
cell A1