View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mr. Clean[_2_] Mr. Clean[_2_] is offline
external usenet poster
 
Posts: 11
Default 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.