G
Guest
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.
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.