View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Manxy Manxy is offline
external usenet poster
 
Posts: 12
Default Easy Peasy Explanation required

Conditional Formatting and the code is a puzzle to me, although I understand
its like maths with brackets etc.
What I'm after is the explanation of the code below.

=AND(G3<,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3)) <=TODAY())

For instance
=AND
<
""
+1
(G3 and which right Parenthesis would this apply to?
()) Where do these apply?
<=TODAY I'm guessing that this implies the information to the left of
this is less than todays date?

Unfortunately, I find it difficult to follow written information, but once
explained and especially shown, I can remember and understand what was stated.

Thanks in anticipation