Topic: Julian /Julienne Dates (97 sr2) @ AskWoody

Julian /Julienne Dates (97 sr2)
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Julian /Julienne Dates (97 sr2)
- This topic has 2 replies, 3 voices, and was last updated 23 years, 4 months ago.
Author

Topic
New Reply

WSMelanieB
AskWoody Lounger

January 25, 2002 at 6:53 pm #365974

ok. I don’t know how to spell it. In addition to that, I don’t know how to convert a regular date to a Julien date. Any ideas – spelling aside, please – I’m embarassed enough!

Reply | Quote

Viewing 1 reply thread
Author

Replies
- WSSammyB
  AskWoody Lounger
  
  January 25, 2002 at 7:25 pm #566283
  
  See Chip Pearson’s Julian Dates.
  
  Reply | Quote
- H. Legare Coleman
  AskWoody Plus
  
  January 25, 2002 at 9:10 pm #566302
  
  The formula below will convert the date in A1 to Julian:
  
  =TEXT(A1,"yy")&TEXT(A1-DATE(YEAR(A1),1,1)+1,"000")
  
  Reply | Quote
Viewing 1 reply thread

Reply To: Julian /Julienne Dates (97 sr2)
You can use BBCodes to format your content.
Your account can't use all available BBCodes, they will be stripped before saving.

Your information:
Name (required):

Mail (will not be published) (required):

Website:

Cancel

Plus Membership

Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.

AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.

Welcome to our unique respite from the madness.

It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

S	M	T	W	T	F	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

Julian /Julienne Dates (97 sr2)

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Key Links

Remembering Woody

Julian /Julienne Dates (97 sr2)

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Login and Registration

Key Links

Remembering Woody