| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel dates
how do i change #(1-365) to the corresponding date in excel?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel dates
It depends on what result you want. If the number is 1, what date do you
want? 1/1/2010? With your number in a1, try the following: =date(2010,1,a1) If that doesn't do what you want, post back with what you want to achieve. Regards, Fred "king2385" wrote in message ... how do i change #(1-365) to the corresponding date in excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
| Excel not recognizing dates as dates | Excel Discussion (Misc queries) | |||
| How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
Linear Mode
