Hi,,,I have a requirement to a julian date (ccyyddd) format to ordinary date. For example corresponding julian date for 01/13/2008 is 2008013.. Last 3 digit gives the number of days in that particular year.. So now i need to do the reverse.. Given a julian date i need to convert it to MMDDCCYY format.. So do you know any method of accomplishing this ?.. typically if we could convert days to months and day we could be fine.. Pls help me on this.. thanks
This has been flagged as spam show
Hi,,,I have a requirement to a julian date (ccyyddd) format to ordinary date. For example corresponding julian date for 01/13/2008 is 2008013.. Last 3 digit gives the number of days in that particular year.. So now i need to do the reverse.. Given a julian date i need to convert it to MMDDCCYY format.. So do you know any method of accomplishing this ?.. typically if we could convert days to months and day we could be fine.. Pls help me on this.. thanks
jimbij007 3 days ago
hi ,
1:58 .. I am not getting this drop down in my excel.. Could you please help me on this.. thanks
jimbij007 3 weeks ago
@jimbij007 , that means you do not have Excel 2010. You must have Excel 2007 or 2003...
ExcelIsFun 3 weeks ago
@ExcelIsFun yeah i do.. so there is no option for the same in older versions?
jimbij007 3 weeks ago
@jimbij007 , none whatsoever.
ExcelIsFun 3 weeks ago
really like your videos. still can't believe you're doing this for free.
elphau 3 weeks ago
@elphau , our job as humans is to make the world a better place and have fun, so this is perfect for me!
ExcelIsFun 3 weeks ago
Great trick Mike. Like the "esoteric" version also, although would ultimately go with the logical IF statement. Thanks.
krn14242 3 weeks ago
@krn14242 , cool! Thanks!
ExcelIsFun 3 weeks ago
Good One...Guys...Try to use this kind of function in ur daily routin work...all this is a part of Advance Function..
Dhawan1988 3 weeks ago
@Dhawan1988 , Okay!
ExcelIsFun 3 weeks ago
This is really cool Sir! Thanks for using my example!
I will probably need to watch it a couple of times though since i'm not an expert in maths :)
That's the advantage of youtube. Watch it over and over and over :D
Once again Thanks! And keep them comming.
skydive911 3 weeks ago
@skydive911 , cool! i am glad that it helped!
Yes, having a rewind button is very handy!!!!
ExcelIsFun 3 weeks ago
@ExcelIsFun Yup I tried it and it worked!!! I will now have to remember the formula! :D
I am just soo glad i was able to do it with your help. Now i can digitaly send my invoice!
skydive911 3 weeks ago
@skydive911 , Yes!!
ExcelIsFun 3 weeks ago