pop-up julian date

[samy]

hello,

the following steps show hoe to insert regular date. what iam looking for to
insert julian date instead. Any idea how????????

1. View..ToolBars...Control Toolbox
2. Click the button for More controls (looks like two hammers)
3. From the list Select "Microsoft Date Time Picker "
4. Drag on sheet for the size of the control
5. Turn off design mode (green triangle on the control toolbox) to use the
DT control

 

[Kevin B]

This doesn't pop-up, but it does calculate the Julian date. The example
below uses A1 as the cell that contains the date:

=A1-DATE(2008,1,0)