| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Julian Date
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Julian Date
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 |
|
#3
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 . |
|
#4
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 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Julian Date
On Mon, 4 Aug 2003 12:05:25 -0700, "jer" wrote:
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 You seem to be using a definition of Julian Date as being the day number of the current year. If that is the case, then: =TODAY()-DATE(YEAR(TODAY()),1,0) will give the desired result. --ron |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Julian Date
On Mon, 4 Aug 2003 12:05:25 -0700, "jer" wrote:
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 Sorry, I forgot this was the programming group when I gave you a worksheet formula. Chip's formula is the same as mine, but in VBA. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Julian date - find next highest date/number | Excel Worksheet Functions | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| to convert a julian date back to regular date | Excel Worksheet Functions | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
| how to convert julian date to regular calendar date | Excel Worksheet Functions | |||
Hybrid Mode
