| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Would like an explanation of a formula:
=("1/1/"&(IF(LEFT(DQ10,4)*1<20,2000,1900)+LEFT(DQ10,4)))+ MOD(DQ10,1000)-1
The other day I needed a formula that would change a Julian date to a calendar date, e.g., 2006031 to 01/31/06. I googled the question and found the answer, for which I am grateful, in a formula provided by Joseph Rubins Excel Tips. It worked like a charm and I was wondering if someone would take the time to explain exactly how it works. Thanks -- Leo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where to find formula & explanation on Compound Interest etc | Excel Discussion (Misc queries) | |||
| FORMULA EXPLANATION | New Users to Excel | |||
| Explanation of when & how to use ( ) { } : ; , ! etc? | New Users to Excel | |||
| Formula Explanation Please | Excel Discussion (Misc queries) | |||
Threaded Mode
