Hi Pev,

I think that you have misinterpreted the help.

Dates should be entered by using the DATE function, OR AS RESULTS OF OTHER
FORMULAS OR FUNCTIONS. For example, use DATE(2008,5,23) for the 23rd day of
May, 2008. Problems can occur if dates are entered as text.

The example uses references to cells with dates.

Regards,

OssieMac

"Pev" wrote:

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.