| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel should have a formula for Converting Julian Dates
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
