ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Figure out date from total days in year (https://www.excelbanter.com/excel-worksheet-functions/226951-re-figure-out-date-total-days-year.html)

bijoutery

Figure out date from total days in year
 
Thank you - that worked!

Unfortunatly they changed the bloody format in the next set of files
so I can't keep using it :p
Now my column of Julian dates reads as 8/27/1900 for a date that
should be in late Jan (perhaps early Feb?) of this year.
Any suggestions for this one? :)

Jennifer

bijoutery

Figure out date from total days in year
 
Ok, never mind - figured out they had the correct day but wrong year
(on top of duplicating data, no wonder it didn't make any sense!)


All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com