Hi all,
I have a spreadsheet tracking a project (start and end dates for various tasks) with resources assigned (via the denotation of a 1) for each of those tasks. I've created named ranges for "Start", "End", and each of the resource columns. I would now like to create a calendar of sorts to look for any gaps in resource utilization. To do this I've created rows for each of the resources and each column next to that is a day. I tried to use if/and functions to return a 1 if a resource is allocated on a given day, but all I get are 0's. Here is what I used:
Will this not work with ranges? Should I be using a lookup instead?
Thanks!
I have a spreadsheet tracking a project (start and end dates for various tasks) with resources assigned (via the denotation of a 1) for each of those tasks. I've created named ranges for "Start", "End", and each of the resource columns. I would now like to create a calendar of sorts to look for any gaps in resource utilization. To do this I've created rows for each of the resources and each column next to that is a day. I tried to use if/and functions to return a 1 if a resource is allocated on a given day, but all I get are 0's. Here is what I used:
Excel Formula:
=IF(AND(Resource=1,Start<=D$5,End>=D$5),1,0)
Will this not work with ranges? Should I be using a lookup instead?
Thanks!