Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Date-picker in Numbers 4.0.5

Recently I saw a date picker option for the newer version of Numbers (4.0.5), where you select a cell and a small calendar appears. But I forget how to enable it. Any help?

Posted on Dec 29, 2016 9:21 AM

Reply
5 replies

Dec 29, 2016 11:03 AM in response to Vorgan Haze

Maybe the iOS version has a date picker, but Numbers on mac OS does not. You can kinda make one like this:

User uploaded file



start with a valid date in cell B1 (I used a formula to guarantee a valid date)

=today()


Then make cell B2 a slider that ranges from some negative value to some positive value... I chose -30 to +30, but you should chose this to suit your needs



Now use the formula in cell B3

=B1+B2

Dec 29, 2016 7:37 PM in response to Vorgan Haze

OK. so I finally found how to do this. Thanks for the screenshot.


The steps are:

1A) select the cell where you want the date picker

1B) pause, then click a second time OR


1) double click the destination cell


2) select the menu item "Insert > Date & Time"

3) single click the highlighted date in the cell


When the cell is not selected to get the date picker

1) double click the cell and, while the date is highlighted,

2) singled click the date

3) now single click the calendar at the bottom right

User uploaded file

Date-picker in Numbers 4.0.5

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.