Excel formula using Julian calendar
Closed
judy
-
Oct 6, 2015 at 03:38 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 6, 2015 at 04:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 6, 2015 at 04:01 PM
Related:
- Excel formula using Julian calendar
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel formula - Guide
- Mark sheet grade formula in excel download - Guide
- How to transfer data from one sheet to another in excel using formula - Guide
- Formula bar in excel missing - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Oct 6, 2015 at 04:01 PM
Oct 6, 2015 at 04:01 PM
"A" part does not seem to make sense. the best i can think that a refers to current calendar year. Also what happens if days are less than 100
any ways based on what you gave this is what you can try
=DATE(YEAR(NOW()),1,1)+MID("A16612009',2,3) -1
any ways based on what you gave this is what you can try
=DATE(YEAR(NOW()),1,1)+MID("A16612009',2,3) -1
