Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
“Jan” in C2
=TEXT(EDATE(DATEVALUE(C2&1),1),"mmm")
EXCEL formula
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hi,
I need to format so 2024 is Year 1 and Jan. 24 is January. Used =EDATE(C2,1), however, this does not work with text.
| 2024 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| jan. 24 | feb. 24 | mar. 24 | apr. 24 | mai. 24 | jun. 24 | jul. 24 | aug. 24 | sep. 24 | okt. 24 | nov. 24 | des. 24 |
| Year 1 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jan. | Feb. | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous