mickeystanford_alumni
Board Regular
- Joined
- May 11, 2022
- Messages
- 129
- Office Version
- 2021
- Platform
- Windows
- MacOS
Hi everyone,
I am trying to find a formula that gives me the month in a format =TEXT(A1,"MMM")
Where A1 is =TODAY() --> 15.09.2022.
In this case, it would give us SEP. However, I want to tell excel that if the day on the month is before the 15th, so from 1st-14th then to report SEP, but if day is on the 15th or after, to report OCT (so the month after).
Could you provide any guidance?
Thank you!
I am trying to find a formula that gives me the month in a format =TEXT(A1,"MMM")
Where A1 is =TODAY() --> 15.09.2022.
In this case, it would give us SEP. However, I want to tell excel that if the day on the month is before the 15th, so from 1st-14th then to report SEP, but if day is on the 15th or after, to report OCT (so the month after).
Could you provide any guidance?
Thank you!