This content has been marked as final. Show 2 replies
First one is actual data, the second is the required result.
let Start = floor(makedate(1971,01,01));
let End = floor(today())+1;
let NoOfDays = End - Start;
$(Start)+recno()-1 as Date
Year(Date) as Year
DROP Table Cal1;
(biff, embedded labels, table is Sheet1$);
Year as Year1
Drop Table A;
All kind of suggestions/solutions are most welcome.