formula

[thair younis]

Hi
I need equation
the explain in attached

[shrivallabha]

Still not clear how the results be calculated?
In Cell B2 [cell formatted as General], try:

=150-(A2-(EOMONTH(A2,-1)+1))*5

[Bob Phillips]

Or just

=N(150-(DAY(A2)*5))

[shrivallabha]

Or just

=N(150-(DAY(A2)*5))
Super :clap:

[thair younis]

thanks a lot Shrivallabha for this
i will try it

[thair younis]

thank you very much Xld it's perfect

[thair younis]

Hi
sir if i wanted it started from (14) in month to (14) from next month
what i should do
thank you

[Bob Phillips]

Try

=N(150-(DAY(A2-14)*5))

[thair younis]

Try

=N(150-(DAY(A2-14)*5))

Thank you so much Xld it's excellent
it working perfectly .
thank you Sir again