check whether a date falls in a range

G

Guest

Hi! I need a formula which will check to see if a date is in a range between
two dates. To complecate further, if the date is in my range the formula must
then calculate a number to display based on a $ value (from elsewhere)
divided by a number of months (again from another speadsheet).

i have come up with;

=IF(B4>=data!E2,(data!H2/data!F2),("")) AND IF(B4<=data!E5,(data!H2/data!F2
),(""))

Clearly this formula doesnt work! Does anybody have any ideas?

What I am trying to do is show customers annual contract amount divided into
an average monthly amount. Obviously each customer has different contract
start and end dates! - i need to see each customer as a different line item,
and future months as columns.

Many thanks
RGB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting based on date range 3
Conditional Sum date range 2
formula to determine whether a date falls between two dates 7
counting blanks in a non-consecutive range 3
Date range within a date range 2
Check date range on three sheets? 1
Please help with a date formula. 3
Conditional sum in a named range 8

Top