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?
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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?
Maybe the iOS version has a date picker, but Numbers on mac OS does not. You can kinda make one like this:
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
I meant to mention that once you have used the slider to get the date you want, select the date in cell B3, copy, then select the cell where you want the date and use the menu item "Edit > Paste Formula Result"
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
Thanks Vorgan and Wayne.
Date-picker in Numbers 4.0.5