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

​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/2024Then that same formula will give me “B” for dates from 1/16/2024 to 1/31/2024Then that same formula will give me “C” for dates from 2/1/2024 to 2/15/2024Then that same formula will give me “D” for dates from 2/16/2024 to 2/29/2024and 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    Read More

​