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

Posted on Mar 13, 2021 6:31 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 14, 2021 1:07 AM

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.

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers 10.3.9 - Insert date-picker

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