Thread: Date Variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ranjith Kurian[_2_] Ranjith Kurian[_2_] is offline
external usenet poster
 
Posts: 48
Default Date Variable

I have created the below variable to get current month and previous month

curmth = Format(Date, "mmm-yy")
prvmth = Format(DateSerial(Year(Date), Month(Date) - 1, 1), "mmm-yy")

and i have made my active cell to value2
dt = Cells(i, 4).Value2

So the active cell convert the date to values/numbers, i need to compare my
above variable with the activecell, as the format are different i am
unsucceful in this.

Could someone advise me how to change my variables(curmth and prvmth) to
values/number (example: 3/9/2009is the date and the number for that is 39881)