Hello,
Just seeing if I can get a little help. So I have a forecast formula =C2/DAY(TODAY())*31 The problem is it doesn't stop at the end of the month at the 31st, it will just keep calculating so the forecast will show some ridiculous number the day after the 31st. I hope this makes sense.
Just seeing if I can get a little help. So I have a forecast formula =C2/DAY(TODAY())*31 The problem is it doesn't stop at the end of the month at the 31st, it will just keep calculating so the forecast will show some ridiculous number the day after the 31st. I hope this makes sense.