Birthday is wrong when moving contacts to numbers

When I transfer a group of contacts to Numbers the birthday is one day off.

iPad, iPadOS 17

Posted on Jan 4, 2025 8:52 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 6, 2025 12:48 AM

"Works fine" can depend on time zones. For example I go back and forth between time zones far apart enough th have a day's offset.


In any case if you are consistently one day off, then you can easily adjust the result in Numbers. Just set up an adjacent column with a formula that adds 1 to the date (or subtracts 1 if it's off in the other direction). Once you've got the dates right, you can "remove" the formula by selecting the cells with the formula, typing command-c to copy, and Edit > Paste Formula Results.


SG


SG

3 replies
Question marked as Top-ranking reply

Jan 6, 2025 12:48 AM in response to Rich Rydalch

"Works fine" can depend on time zones. For example I go back and forth between time zones far apart enough th have a day's offset.


In any case if you are consistently one day off, then you can easily adjust the result in Numbers. Just set up an adjacent column with a formula that adds 1 to the date (or subtracts 1 if it's off in the other direction). Once you've got the dates right, you can "remove" the formula by selecting the cells with the formula, typing command-c to copy, and Edit > Paste Formula Results.


SG


SG

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.

Birthday is wrong when moving contacts to numbers

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