I've tweaked some code for a pop up date picker I found here:
I'd like to have the date picker "remember" the date value in the cell if I double click on it. Currently, I can change the date and it stays in the cell but if double click the cell again, it defaults back to the current date.
In other words, if I change the date and double click the same cell, I want it to show that date. If the cell is blank, then show current date on the form.
Also, I'd like the date in the cells to be mm/dd/yy but still show the month name, month dd, and month yyyy on the actual date form picker as it does now.
I've attached an example file. Thank you.