Tech Tip: Julian Date Conversion, Excel Formulas

May 21, 20191 min read

Tech Tips

Excel date formulas:Julian to Gregorian: =DATE(1900+(A1/1000),1,1)+VALUE(RIGHT(TEXT(A1,"0"),3))-1Gregorian to Julian: =(YEAR(A1)-2000+100)*1000+A1-DATE(YEAR(A1),"01","01")+1

Continue reading

All insights

Company News

AI in Business: What Holds Leaders Back and How to Fix It

AI initiatives perform better when aligned to business outcomes rather than driven by technology selection.

May 27, 2026Read article

Company News

Moving Beyond Reports: How Analytics as a Service Turns ERP Data into Action

Most organizations don’t lack data. The real challenge is turning that data into clear, guided decisions, not just reports.

May 27, 2026Read article

Case Studies

Project Profile: Delivering mission-critical custom financial reporting for an Oracle Cloud environment

Oracle Cloud Financials reporting support using Oracle BI Publisher / OTBI & managed services support for custom report development and deployment

May 6, 2026Read article

Ready to talk it through?

No sales pitch, no pressure — honest advice from people who know the JDE world.

Book a Conversation