I built this spreadsheet to manage all my familly’s expenses:
https://docs.google.com/spreadsheets/d/1UBGZj1zuZSUzYWH2vpitfLLud32e-efKKVuKQ2UWPrA/edit?usp=sharing

I am trying to calculate the serial number from a date value in javascript.
Basically I am looking for a equivalent javascript implementation for =DATEVALUE of google sheets.

I need a function or a formula in a cell (example: A2) that gives the border of cell (example: A1) in a format like ####, with # being 0 or 1, depending if there is an active border in the positions LTRD (left, top, right, down).

I am working on filtering a Google Sheet for data and creating time series charts off of it with each athlete as a different series on the graph. The graph is being created properly but I cannot figure out how to set the legend labels on the graph using the built in functions.