How many days left in the current month

for the variations you need, my suggestions will not work well. @jasonb's formula is recommended for your purposes.

i have updated @jasonb's formula to fit your needs in the attached workbook. you have to decide whether you want to include TODAY's date in day's left or day's gone. accordingly, use the TODAY()+/-1 in the appropriate formula.