| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function in ACCRINTM requires date format not available
The date entry in the ACCRINTM formula requires the date to be in as
year,month,day ie 2007,10,13 for 13th October 2007 but there is no option to save dates in that format when formatting the cells as DATE or CUSTOM. This makes it very tedious to have to amend each date from a column of dates when I should be able to paste the cell containing the date into this formule. How do I achive this? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| date format and the RIGHT function | Excel Worksheet Functions | |||
| date format and the RIGHT function | Excel Worksheet Functions | |||
| date format and the RIGHT function | Excel Worksheet Functions | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Threaded Mode
