How to show data between two dates?
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. |
How to show data between two dates?
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, "") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "BWAK424" wrote: 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. |
How to show data between two dates?
What If formula did you try? Are your values real dates (formatted as
dd-mm), or are they text? Regards, Fred "BWAK424" wrote in message ... 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. |
How to show data between two dates?
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 ,"") -- Jacob "BWAK424" wrote: 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. |
All times are GMT +1. The time now is 02:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com