Stop forecast formula

[Erkjerk]

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.

 

[Skybluekid]

How about
=IF(DAY(TODAY())>31,"",C2/DAY(TODAY())*31)

Hope this helps

 

[Erkjerk]

Looks like it is still pulling the super large number. I am thinking it could be cause of the (today) formula or something?

 

[Skybluekid]

Is this designed to stop calculation when then end of the month comes? If so, you could use:

=IF(TODAY()>EOMOTH(TODAY(),0),"",........

 

[Fluff]

Today will never be greater than the end of this month.

 

[Erkjerk]

Today will never be greater than the end of this month.

Good point lol

 

[Erkjerk]

=IF(TODAY()>EOMOTH(TODAY(),0),"",........

I feel stupid, what is the ..... I appreciate the help!

 

[Skybluekid]

Very good point @Fluff

 

[Skybluekid]

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.

Looking at this with fresh eyes, is the 31 the number of days of the month? Does this change to correspond to the number of days for a given month?

 

[Erkjerk]

Looking at this with fresh eyes, is the 31 the number of days of the month? Does this change to correspond to the number of days for a given month?

That is correct