I have a task where I export data from MS Project into Excel. The date comes across as text and accompanied by "day" and "time." What is the best formula in Excel that I can apply against the exported "date" data that will strip the "day/time" off and convert the date to a true julian date? Thanks in advance! I truly appreciate the guidance. ~bonga
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Date conversion from MS Project to MS Excel
Similar threads
- Question
- Question
- Question
- Solved
