Forum Discussion
Need a formula to get a CHAR() letter
Hello All,
It seems I am having some creativity issues!!! 😞
What I need is to get a formula to deliver a letter using the CHAR() function, or any other way.
What I have is the following (All Dates are in MM/DD/YYYY US format):
In Column A I have dates: 1/1/2024, 1/2/2024, 1/3/2024.... 12/30/2024, 12/31/20204.
In Column B I need a formula that would give me an "A" for dates from 1/1/2024 to 1/15/2024
Then that same formula will give me "B" for dates from 1/16/2024 to 1/31/2024
Then that same formula will give me "C" for dates from 2/1/2024 to 2/15/2024
Then that same formula will give me "D" for dates from 2/16/2024 to 2/29/2024
and so on. For each 1-15th day I need a letter and then from the 16th to the end of the month a different letter.
This way I can group the dates in separate groups based on the letter.
Thanks in advance for any help!
GAL
- GeorgieAnneIron Contributor