Forum Discussion

GeorgieAnne's avatar
GeorgieAnne
Iron Contributor
May 20, 2024

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

 

 

Resources