Re: Returning $ values by start & finish dates only

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try :
=(G1-$E$2<8)*$B$2+((MIN(G1,$F$2)-MAX(F1,$E$2-1))*$D$2/7)+(G1>$F$2)*$C$2
Have a look at :
http://www.filedropper.com/returningvaluesbystartfinishdatesonly_1
Daniel
Matt a formulé la demande :
Thanks David but that doesn't fix it either. I think there is another issue too where cell B2 isn't referenced anywhere within the formula. Any help would be great.
--
Regards
Matt


"David Biddulph" wrote:

Rather than changing a semi-colon to a colon, try changing it to a comma. (Semi-colon and comma are the alternatives for a list separator, depending on the regional settings).
--
David Biddulph

"Matt" <Matt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B4CD901E-132B-4B89-9235-5FD4C0E9D28C@xxxxxxxxxxxxxxxx
Thanks for the response Daniel.
Unfortunately it doesn't work. I copied and pasted your formula into G2 and
hit enter. Received error message and proposed correction changed ; to :
within your formula. I accepted this change and it still didn't work. I
have tried to solve this myself but to no avail. Any ideas?
--
Regards
Matt


"Daniel.C" wrote:

In cell G2 :
=(G1-$E$2<8)*$C$2+((MIN(G1;$F$2)-MAX(F1;$E$2-1))*$D$2/7)+(G1>$F$2)*$C$2
to be pasted in H2, I2 and dragged downward as far as needed.
Regards.
Daniel

Aim: Calculate weekly cost of all equipment using mobilisation (mob),
demobilisation (demob) and weekly rates.

Source data: Mob and demob dates only.

My spreadsheet currently looks like below (Date format eg Xmas = 25-12-08).
Dates shown are for end of week (Friday). Costs tally up in columns G, H and
I.

A B C D E F
G H I
1 Equip $/Mob $/Demob $/Wk Mob Demob 31-10 07-11
14-11
2 EWP 100 100 700 29-10 13-11 400
700 700
3 Fork 100 100 700 05-11 10-11 0
400 400
4
Totals 400 1100 1100

G3 = $100/mob + 3 days (3/7 x $700 = $300) = $400 total

I am looking for a formula to insert into G2, H2, I2, G3, H3 and I3 to
achieve the results shown. Formula needs to reference date entries in E2,
F2, E3 and F3. Any help would be appreciated. Thanks.








.

Relevant Pages

  • Re: Returning $ values by start & finish dates only
    ... Well it does work but you have to change the demob date. ... Daniel ... Received error message and proposed correction changed; ... Formula needs to reference date entries in ...
    (microsoft.public.excel.misc)
  • Re: Tired of bumping along to Oshkosh?
    ... Matt, what kind of reference could I use that would be acceptable to you, ... the engines that I was referring to are 40-50 years old and I was providing ... my information from my personal memory, yes I know, sometimes I have a great ...
    (rec.aviation.homebuilt)
  • Re: stop excel changing formulas
    ... If I was Matt I would try to describe the problem in more details. ... no matter if absolute or relative reference, ... conditions make adjustment to this. ...
    (microsoft.public.excel.misc)
  • Re: Spoiler - Tuesday - Passports
    ... Is it really likely that the police would have allowed Matt to keep his ... passport while he was on bail? ... I thought there was a reference to them ...
    (uk.media.radio.archers)
  • Re: Tired of bumping along to Oshkosh?
    ... In retrospect I have to concur with your point Matt, ... around and see if I have any old USAF tech manuals, ... >> provided the fort belvoir link on fuels stated the same information that ... >>>one who hasn't provided a reference to support his position. ...
    (rec.aviation.homebuilt)