| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
2 questions regarding Dates
Q1
I have inherited a spreadsheet that has the date split over 3 columns: - a1 = day b1 = month c1 = year How can I put these in one column to read dd/mm/yyy Q2 How can I work out the day number of a particular date? Ie 28/10/2004 = 302 I also need to take into consideration the leap years accordingly TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
| Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
| Dates Subtracting dates. | Excel Discussion (Misc queries) | |||
| Can I get email alerts when dates in excel are nearing? | Excel Discussion (Misc queries) | |||
| Dates in spreadsheets | Excel Discussion (Misc queries) | |||
Threaded Mode
