| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of year (Not Julian)
I am using this formula from Chip Pearson's web site.
'====== =RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000") '====== Which will take a date "04/18/08" and display it as "08109". "08" is the year while "109" is the day of the year. 1. I need to strip the leading zero's 2. How can I make a column convert a date to this format when ever a date is entered? -- Regards XP Pro Office 2007 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I crate a function for week of year + year in same cell. | Excel Worksheet Functions | |||
| how to convert from julian date to mm/dd/year | Excel Discussion (Misc queries) | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| converting julian day and year to a date? | Excel Worksheet Functions | |||
| Excel should support DAYOFYEAR(year,month,day) returns julian dat. | Excel Worksheet Functions | |||
Threaded Mode
