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
