Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add Number to variable date | Excel Programming | |||
variable for Date | Excel Programming | |||
add 1 day to date variable | Excel Programming | |||
calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
Compare Date in Cell VS a Variable Date to Hide Row | Excel Programming |