Numbers 10.3.9 - Insert date-picker
How do I insert a date-picker calendar into a cell in Numbers?
MacBook Pro 13″, macOS 10.15
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.
How do I insert a date-picker calendar into a cell in Numbers?
MacBook Pro 13″, macOS 10.15
Hi moni_chan65,
That is not a feature in Numbers. All I can suggest is to enter the year, month and day in this table:
Formula in E2: IF(OR(B2="",C2="",D2=""),"",DATE(B2,C2,D2))
The "IF OR" keeps column E blank until columns B, C and D contain values.
Please call back with a description of your overall aim.
Regards,
Ian.
You get close to a date picker on iPadOS.
Tap 'today' and then + by month, etc.
On MacOS, Numbers is less convenient for inserting dates, but you can insert today by clicking a cell going to Table > Insert Date (or using the keyboard shortcut.)
SG
Numbers 10.3.9 - Insert date-picker