Dates from Julian calendar
I know it can be done - just don't know how! Embedded into barcodes we use the Julian date system. I need people to enter the julian date into the spreadsheet and the adjacent cell to display the date. Excel seems to give every possible way to convert to Julian dates but not the other way round Can anyone please help this numpty? Thanks Tony -- y_not ------------------------------------------------------------------------ y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947 View this thread: http://www.excelforum.com/showthread...hreadid=478831 |
Dates from Julian calendar
Have a look here,
Regards, Alan. http://www.cpearson.com/excel/jdates.htm "y_not" wrote in message ... I know it can be done - just don't know how! Embedded into barcodes we use the Julian date system. I need people to enter the julian date into the spreadsheet and the adjacent cell to display the date. Excel seems to give every possible way to convert to Julian dates but not the other way round Can anyone please help this numpty? Thanks Tony -- y_not ------------------------------------------------------------------------ y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947 View this thread: http://www.excelforum.com/showthread...hreadid=478831 |
All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com