pop-up julian date

  • Thread starter Thread starter samy
  • Start date Start date
S

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
 
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)
 
Back
Top