Can you please help,
I need to have a formula in Cell A1
If Today's date > = 1st and < = 14th then
CELL A1 = 16th of Previous Month -- CELL B1 = Last day of Previous month.
If Today's date = 15th then
CELL A1 = 1st of Current Month -- CELL B1 = 15th of Current Month
If Today's date > = 16th and < = End of Month then
CELL A1 = 16th of Current month. -- CELL B1 = Last day of Current month.
not sure if this can be done in one formula,
if not, I'm OK with 2 formulas (CELL A1, B1)
Any help is appreciated,