Forum Discussion
Solved
help with complex formula involving dates
I need to change the formula in the column labeled "Invoice Month" (see screen shot). Currently it's this: =CHOOSE(MONTH(D3),"January","February","March","April","May","June","July","August","Septemb...
Hi Tatiana,
Perhaps instead of MONTH(D3) you may use
MONTH(D3)+(DAY(D3)>22)
in your formula
Hi Tatiana,
Perhaps instead of MONTH(D3) you may use
MONTH(D3)+(DAY(D3)>22)
in your formula
this worked, thank you!!
You are welcome