Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date calc returning #name?
I am trying to figure out what is wrong with my Else formula. The
"begrevdate" is the name of a cell which contains a date with format "MM/DD/YY". The intermediate window shows: ?lastdate 3/31/05 ?begrevdate 12:00:00 AM I don't understand why begredate is not returning a date when a date is present in the cell. The result of the code in the sheet is #name? With Range("a" & numberrows + 2) .NumberFormat = "0.00" .Name = "revtime" If ans = vbNo Then 'calculates review period based on real-time date .FormulaR1C1 = "=(today()-begrevdate)/365" Else: .Formula = "=(lastdate-begrevdate)/365" End If End With Thanks for your thoughts |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calc. an anniversary date(50 years) after marriage date in excel | Excel Worksheet Functions | |||
ND TO CALC FROM ORIG DATE TO NEXT DATE RECEIVED? | Excel Discussion (Misc queries) | |||
Calc End Date | Excel Worksheet Functions | |||
Date Calc. HELP | New Users to Excel | |||
calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions |