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.
Is there a function which formats a date in Numbers? (I have version 11.2 (7032.0.145).)
Something like
FORMAT(A1, "dd-mmm")
to take a date/time in cell A1 and display it using the format. A date/time today would return "08-Apr". I've seen that one can access the displayed date using
A1&""
but it's pretty clumsy to create a scratch cell just to set the format.
It would be handy but it is not available.
If the cell where you want to display the date will be only the date (not with other text), format the cell to display it the way you want it. No need for a function to do it. If it will be part of other text then I think the best solutions are to either format cell A1 the way you want it to be displayed or, like you said, use a scratch cell (which can be in a hidden column). You could also use some of the built-in date and text functions to create the format you want.
This will create your format from the date in A1
=RIGHT("0"&DAY(A1),2)&"-"&LEFT(MONTHNAME(MONTH(A1)),3)
It would be handy but it is not available.
If the cell where you want to display the date will be only the date (not with other text), format the cell to display it the way you want it. No need for a function to do it. If it will be part of other text then I think the best solutions are to either format cell A1 the way you want it to be displayed or, like you said, use a scratch cell (which can be in a hidden column). You could also use some of the built-in date and text functions to create the format you want.
This will create your format from the date in A1
=RIGHT("0"&DAY(A1),2)&"-"&LEFT(MONTHNAME(MONTH(A1)),3)
I may be missing something but won't setting up a Custom Format do what you want?
Go to Format > Cell > Data Format and choose Create Custom Format from the dropdown.
Once create, you can apply it to any cells where you want dates formatted that way.
SG
Thanks, Badunit -- Would be nice if there was a formatting function, but you're right, formatting in script works.
RIGHT("0"&DAY(A1),2)
works nicely to get the prefix zero. It's been a while since I needed to go to that level. :-)
Formula to format a date?