How to show data between two dates?

B

BWAK424

I have a list of tenants and the dates they moved in and out of their flats.
I need to show which weeks within a specific period that the flats were
filled - either by showing the tenants intials or a tick.

A B C D E
F G H
Unit No Client Start End 04-01 11-01 18-01 25-01
1 JB 23-11 06-02 JB
2 GK 05-01 GK GK GK GK
3 LB 01-12 28-02 LB LB LB LB

Does anybody know how is best to do this? We've tried using an IF formula
but it doesn't work if their is a start and end date.
 
L

Luke M

Assuming that your start/end dates, and header dates are truly entered as
numerical dates, your formula in E2 is this:
=IF(AND(E$1+6>=$C2,OR(ISBLANK($D2),E$1<=$D2)),$B2,"")
 
F

Fred Smith

What If formula did you try? Are your values real dates (formatted as
dd-mm), or are they text?

Regards,
Fred
 
J

Jacob Skaria

In cell E2 enter the below formula and copy down/across as required...

=IF(MEDIAN($C2,IF($D2="",TODAY(),$D2),E$1)=E$1,$B2,"")
 

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

Top