Help with Date checking code
How would I change
this condidtion to check for a value
whe
PLEXP is = Date and
the Month of PLEXP is <= Next Month
Also taking into consideration a Dec/Jan
value combination. (PLEXP Month is Dec)
If ((DateValue(PLEXP) = Date) And _
(DatePart("M", DateValue(PLEXP)) <= _
(DatePart("M", Date) + DatePart("M", Date) + 1))) Then
I can't quite get it right. Not used to VBA.
|