Hello! I've used VLOOKUP to help find the dates of each item and with the help of other users the calendar is currently set up to show estimated time for future years in regards to the cycle days however since some cycles are 365 years is there a way to show multiple cycles for the future and change dynamically once the time comes to continue showing into the future? Also is there a way to do that with the past times its been purchased to show the estimated time for previous years. I was thinking of possibly using VLOOKUP to find the estimated time for past years and link it to the date in the title of a column or maybe using the same method for adding cycles but subtracting cycles? Although when doing that I dont know how it would react to there possibly being a missing order in the cycle? If there is any way I can elaborate to make things clearer please let me know and thank you for your help!
Bookmarks