| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel should have a formula for Converting Julian Dates
What you posted is a formula, isn't it? Here's some info
http://www.cpearson.com/excel/jdates.htm Regards, Peo Sjoblom "Yakimeshi" wrote: I would like to have a formula or an easy way to convert from Julian Dates into normal gregorian dates. And backwards, instead of this: =TEXT(A2,"yy")&TEXT((A2-DATEVALUE("1/1/"&TEXT(A2,"yy"))+1),"000") ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula in an Excel comment | Excel Discussion (Misc queries) | |||
| Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
| Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Threaded Mode
