| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Julian dates
How does one convert dates that were entered in a date data type format then
erroneously turned to Julian format by copying them into a general or text data type feild back to the correct date format? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Julian dates
Hi Lara,
Following formula should do the job : =DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1 ,RIGHT(A1,3)) HTH Cheers Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| JULIAN DATES? | Excel Worksheet Functions | |||
| Converting Julian Dates to regular dates | Excel Worksheet Functions | |||
| Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
| Julian dates | Excel Discussion (Misc queries) | |||
| julian dates | Excel Discussion (Misc queries) | |||
Linear Mode
