post the formula you want in the cell.

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
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