HP Forums
HP Prime Spreadsheet date entry - Printable Version

+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: HP Prime Spreadsheet date entry (/thread-15058.html)



HP Prime Spreadsheet date entry - dscott1524 - 05-25-2020 05:58 PM

I seem to be unable to enter a date or a time in a Prime spreadsheet. I searched the docs w/o success. Any thoughts?


RE: HP Prime Spreadsheet date entry - froehlic - 05-26-2020 10:11 PM

In Prime all dates have the format yyyy.mmdd .
So, the 27th of may in 2020 you have to write as 2020.0527.


RE: HP Prime Spreadsheet date entry - pinkman - 05-27-2020 12:30 AM

It implied you use date functions such as DDAYS, DATEADD inside the celle formulas.