Dynamic Date Validation and Computation
I'm almost embarrassed to post the following because I recognize it as a horribly constructed formula, but I am experimenting. First, let me highlight my use case:
I have a sheet (first screen shot) that pulls in Start/End Date, Hrs/week, and Hourly Rate via INDEX formula. I'm attempting to have the sheet dynamically calculate a dollar value if the Start/End Date fall within a particular month. If it does not make the cell $0. I'm aware based on previous feedback that I need feeder cells or a reference sheet. I've created the reference sheet (second screen shot), but the formula is not surprisingly spitting out a 'UNPARESABLE' error message.
I think this is a fairly complex ask, but if anyone can provide some guidance I'd really appreciate it.
Help Article Resources
Check out the Formula Handbook template!