pop-up julian date
 

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

--
samy

pop-up julian date
 

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)

--
Kevin Backmann


"samy" wrote:

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

--
samy