| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
The more the merrier IMO
"Duke Carey" wrote in message ... Bob - Yeah, sure, that is clearly easier, better, etc., but the OP didn't ask for the 'best' idea, just for 'any' ideas. Still not enough sleep last night. "Bob Phillips" wrote: "Duke Carey" wrote in message ... You'll need to use a helper column in which you put a text formula along the lines of this (assuming your first date is in A1) =year(A1)&text(month(a1),"00")&text(day(a1),"00") =TEXT(A1,"yyyymmdd") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determining the number of specific days between two dates in Excel | Excel Worksheet Functions | |||
| Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
| Find number of days between to dates | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
