Hey guys,

Trying to make a formula using EOMONTH that will show the last day of the following month.

I need it just to display in the cell the formula is in.

So for example:

Today is the 17th of December, the formula should know as we are past 6th of December, then return the last day of January

If today was the 1st of January, still show 31st of January, if today was however the 6th of January, display 28th of Februaru,

And if today was the 25th of January, display 28th of February


Basically need the formula to know that if today is past the 6th of the current month, then display the last day of the next month, but if today if before the 6th of the current month, display the last day of that month.

Thanks