SOLVED

Iron Contributor

# 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

2 Replies
best response confirmed by GeorgieAnne (Iron Contributor)
Solution

# Re: Need a formula to get a CHAR() letter

In B2:

=CHAR(63+2*MONTH(A2)+(DAY(A2)>15))

Fill down.

# Re: Need a formula to get a CHAR() letter

Hello @Hans Vogelaar

You are the GREATEST!!! Thanks...
G
1 best response

Accepted Solutions
best response confirmed by GeorgieAnne (Iron Contributor)
Solution

# Re: Need a formula to get a CHAR() letter

In B2:

=CHAR(63+2*MONTH(A2)+(DAY(A2)>15))

Fill down.