I have a workbook that has several sheets. 40 of the sheets are combined into a summary sheet. I need help with a formula.
Here is what I need it to do:
On Sheet "1" if load date=6, then show B47
On Sheet "1" if return date =6, then show B47
On Sheet "1" if 6 is between load date and return date, then show B47.
Any suggestions?
Here is what I need it to do:
On Sheet "1" if load date=6, then show B47
On Sheet "1" if return date =6, then show B47
On Sheet "1" if 6 is between load date and return date, then show B47.
Any suggestions?