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.
Hello! I am trying to get cell B2 to display the date range values for C2 & O2, however I want the output dates to be formatted as the month & day values only (like the other cells are formatted). Is there a formula that I can achieve this with? I tried just going to Cell>Format>Date * selecting the month/day option, but I assume it wasn't the correct formula so the formatting selection didn't apply.
Thank you!
iMac 27″ 5K, macOS 13.1
In B2 try this:
=MONTHNAME(MONTH(C2)) & " " & DAY(C2)&"-"&MONTHNAME(MONTH(O2)) & " "&DAY(O2)
SG
In B2 try this:
=MONTHNAME(MONTH(C2)) & " " & DAY(C2)&"-"&MONTHNAME(MONTH(O2)) & " "&DAY(O2)
SG
I got this error
Ladyag2010 wrote:
I got this error
Your formula refers to P2, which isn't shown in your screenshot. What do you have in P2? In your first screenshot that was not a date. Did you mean O2 instead?
SG
I think I got mixed up with the appropriate cell for some reason. I made sure the cells lined up with the correct dates & the original formula you gave me worked. Thank you!!
Numbers Date Range Value
