| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WS formula for Julian date not converting well to VBA??
I found the formula on Chip Pearson's site for converting a date to a Julian
date. When I try to use it as a VBA-inserted formula, it's not working out. I keep getting an error message telling me "Expected: a close parenthesis after the second YEAR". But doing that doesn't work. Can someone point me to my error? ws.Range("E1").Formula = "AR"& RIGHT(YEAR(Range("B1")),2)& TEXT(Range("B1")-DATE(YEAR(Range("B1")),1,0),"000") TIA Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to show when the julian date changes | Excel Discussion (Misc queries) | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| converting julian day and year to a date? | Excel Worksheet Functions | |||
| Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
| Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
Threaded Mode
