Calculating days between two dates and multiply them with different numbers

  • Thread starter Thread starter seemas_mail
  • Start date Start date
S

seemas_mail

What type of formula would I use for this calculation?

8/1/2001-5/4/2004
if the dates are between 7/1/2001-6/30/2002 count all the
days and multiply by 40
if the dates are between 7/1/2002-6/30/2003 count all the
days in between and multiply by 50
if the dates are between 7/1/2003-6/30/2004 count all the
days in between and multiply by 60 and so on
 
this should get you started
=SUMPRODUCT((E1:E5>=DATEVALUE("7/1/2001"))*(E1:E5<DATEVALUE("7/1/2002")))*40
 
Please help me!

This is very good suggestion but it does not solve my
problem. May be I am not using this function correctly.

I am given worksheets of just dates as follow

5/7/01-8/6/03
4/3/04-5/8/04
2//11/03-5/19/04 and so on

and now I have break it down to something like this
anything less than or equal to -6/30/02 it's charged 40
per day
between 7/1/2002-6/30/2003 it would be 50 per day
between 7/1/2003-6/30/2004 it would 60 per day
 
Hi
try splitting these range in tWO separate cells and the unse the
formula suggested (just replaicng the DATEVALUE parts with a cell
reference
 
Back
Top