DDRA Steampunk
New Member
- Joined
- Feb 10, 2017
- Messages
- 23
Hi there 
I have a workbook that tracks earnings per each day of an event, different events have different names, but many are several days long and some dates have more than one event on the same day. I need a formula that can look up the number of days I have on the NEXT sheet, then add 1 to the result to get the new day count on the current sheet only if the day's Event has the same name. The reason it has to be NEXT not PREV is that the sheets run with the newest date closest to my left index page (to prevent having to scroll endlessly through 52 weeks of sheets to get get to today's date). Because I insert new events into the book as they are confirmed I don't want to manually link each one and a dynamic reference would be much better. Thanks in advance for your help!
-Dava
I have a workbook that tracks earnings per each day of an event, different events have different names, but many are several days long and some dates have more than one event on the same day. I need a formula that can look up the number of days I have on the NEXT sheet, then add 1 to the result to get the new day count on the current sheet only if the day's Event has the same name. The reason it has to be NEXT not PREV is that the sheets run with the newest date closest to my left index page (to prevent having to scroll endlessly through 52 weeks of sheets to get get to today's date). Because I insert new events into the book as they are confirmed I don't want to manually link each one and a dynamic reference would be much better. Thanks in advance for your help!-Dava
