Excel formula using Julian calendar
Closed
judy
-
Oct 6, 2015 at 03:38 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 6, 2015 at 04:01 PM
rizvisa1 Posts 4478 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
- Number to words in excel formula - Guide
- How to refresh calendar on mac - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel color formula - Guide
- Formula to calculate vat in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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
