A long long time ago on a forum far far away, I learned how to convert (for example) "2001-2004" into "2001, 2002, 2003, 2004"
The function was =splityears(A1) (A1 being the cell where "2001-2004" was located).
It still works on the old original spreadsheet. But it does not work on new spreadsheets. I recall I had to activate something on the spreadsheet to make it work, but can't remember what that activation was.
Can someone help me remember?
best,
Howard
Bookmarks