* Helped a co-worker to solve his questions, and make my own notes *
How to transfer between Date and Julian Date format
Date: May 1, 2017 (A6)
Julian: 2017121 (B6=YEAR(A6)&TEXT(A6-DATE(YEAR(A6),1,0),"000")
Reversed back (C6=DATE(LEFT(B6,4),1,RIGHT(B6,3))
Blog Archive
-
▼
2018
(59)
-
▼
January
(14)
- Working Memo - right tone in an email
- EXCEL EXCEL - Subtotal vs. Pivot Tables
- On writing well
- Pumpkin day
- Memory of South Africa ~ Sunshine through the window
- Memory of South Africa ~ sunshine through the window
- Working Memo - Insert a screenshot in Office 365
- Career notepad ~~ points about
- Tax Diary >> Term employee, sole proprietorship o...
- Excel Excel - Numbers in icon format -
- Read and share ~ Challenge
- Excel Excel - Display a sheet name in a cell -
- Excel Excel - Date and Julian Date format -
- Coffee to start ~
-
▼
January
(14)