Re: Pop up Julian date

Hi Samy,

What exactly are you trying to do? Convert a Gregorian Date to Julian? If not, I can't see why Excel's standard date functions wouldn't suffice - there won't be another leap-year difference until the start on next century. Surely you aren't planning your entertainment schedule that far ahead ...

--
Cheers
macropod
[MVP - Microsoft Word]


"samy" <samy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FA65EFD8-5E94-40BB-B0C7-2F2D14CDFF21@xxxxxxxxxxxxxxxx

I am sorry, I meant Julian calendar, then once you click on the cell
Julian calendar will pop up and you select the date then will be inserted in
the cell.


Thanks
--
samy


"macropod" wrote:

Hi Samy,

What do you mean by 'julian date'? A julian day number, a julian calendar date, or something different? Some people call a year
number followed by a day number a 'julian date', which it is not - the only true 'julian date' is one that belongs to the julian
calendar.

--
Cheers
macropod
[MVP - Microsoft Word]


"samy" <samy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1D214167-A7CC-480D-82D9-61851503005B@xxxxxxxxxxxxxxxx
>
> Any one help me to figure out how to create julian date pop up i have the
> table already, but do i need to use macro?? or can any one help with that !!
>
>
> Thanks
> -- > samy



.

Relevant Pages

  • Re: Julian date function
    ... according to the algorithm of the Julian calendar ... ... Yes, you are of course correct, the Julian calender uses %4 for leap years, ... whereas the Gregorian uses some extra conditions ... // Routines for processing dates in the format JDN. ...
    (microsoft.public.vc.language)
  • Re: Pop up Julian date
    ... when ever i click on a cell i want the table to pop up and select the julian ... Convert a Gregorian Date to Julian? ... > I am sorry, I meant Julian calendar, then once you click on the cell ...
    (microsoft.public.excel.misc)
  • Re: Help in CalenderAPI
    ... I have found some details about the Julian calendar as follows: ... the cutover date to Long.MAX_VALUE it means GregorianCalendar now have ... To obtain a pure Julian calendar, ...
    (comp.lang.java.programmer)
  • Re: Julian Day Number
    ... I was using the term in an astrophysics context, but I guess shouldn't have assumed everyone would know what I was talking about. ... number on the order of 2,400,000 for dates near the present, potentially including a fractional part for time of day) and go back to a system devised by Julius Scaliger a few centuries ago. ... The "Julian Calendar" of Julius Caesar is unrelated. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Help in CalenderAPI
    ... i read the guideline that are realy help full for writing mails..... ... also let me knw more about how to get the date for proleptic Julian ... GregorianCalender and SimpleDateFormat but still not able to ... BC in the proleptic Julian calendar [" ...
    (comp.lang.java.programmer)