Function to detrmine start and end of month

[YasserKhalil]

Hello everybody
I need your help to make this function work

Please Login or Register  to view this content.

I tested it but I got no result
I want to check a date in a cell and if this date is greater than 17 Dec. and less than 16 Jan. the result should be "January"

[romperstomper]

The date can't be greater than 17 Dec and less than 16 Jan of the same year!

[YasserKhalil]

So how it can be fixed? I tried

Please Login or Register  to view this content.

but no vain

[YasserKhalil]

I tried this function but I got incorrect results at some dates

Please Login or Register  to view this content.

[romperstomper]

Your code isn't entirely clear, but assuming any day after 17 should belong to the following month, try this:

Please Login or Register  to view this content.

[YasserKhalil]

Really wonderful , fantastic, amazing
I can't imagine it would be so easy like that
You are perfect Mr. romperstomper