|
Posted to microsoft.public.excel.programming
|
|
|
Julian Date
Thanks Chip, the formula works just fine
jer
-----Original Message-----
jer,
Try
ActiveCell = Int(Now) - DateSerial(Year(Now), 1, 0)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"jer" wrote in message
...
Dear all
I hope I addressing the correct group. Is there a way
to
program excel to fill an array with the julian date
example.
If activecell.value < " " then ...
actuvecell = Julian Date (today = 216)
End if
thanks
jer
.
|