julian date2.xlsx
I want to input dates but by a data validation list. I want to keep the day, month and year separate. Then I want to convert this to a julian date. How do I do this?
I attached an older file by mistake and don't know how to delete it. Download Julian date2.xlsx and ignore Julian date.xlsx
Last edited by rookie37; 08-03-2014 at 02:43 AM.
Excel 2007
please find attached sheet, this may help you to solve your issue.
thanks
This method converts the date that you enter via the drop down lists to an Excel recognizable date then converts it to Julian using the method for converting dates found at http://office.microsoft.com/en-ca/ex...er_today_as_a_
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks