View Full Version : formula
thair younis
03-07-2012, 06:32 AM
Hi
I need equation
the explain in attached
shrivallabha
03-07-2012, 07:03 AM
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
03-07-2012, 07:57 AM
Or just
=N(150-(DAY(A2)*5))
shrivallabha
03-07-2012, 09:04 AM
Or just
=N(150-(DAY(A2)*5))
Super :clap:
thair younis
03-07-2012, 10:25 PM
thanks a lot Shrivallabha for this
i will try it
thair younis
03-07-2012, 10:27 PM
thank you very much Xld it's perfect
thair younis
03-07-2012, 10:55 PM
Hi
sir if i wanted it started from (14) in month to (14) from next month
what i should do
thank you
Bob Phillips
03-08-2012, 01:35 AM
Try
=N(150-(DAY(A2-14)*5))
thair younis
03-08-2012, 08:03 AM
Try
=N(150-(DAY(A2-14)*5))
Thank you so much Xld it's excellent
it working perfectly .
thank you Sir again
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.