Hi,
In the attached Sample Sheet, I'd like to be able to VLOOKUP in Cell C7 the Period Factor in Cells I5 through I50 based on Today's date in Cell E4. So, for next year's December 31st, I'd like to be able to see 26.5 in Cell C7. In the Sample Sheet, I've hard-coded the Date of Cell C5 into my VLOOKUP formula in Cell C7. I can't seem to be able to figure out how to increment Cell C5 when Cell E4 changes to a new December 31st in subsequent years.
Any help is appreciated. Please if you can, make changes to the attached Sample Sheet and re-post with your solution for my download.
Thanks
In the attached Sample Sheet, I'd like to be able to VLOOKUP in Cell C7 the Period Factor in Cells I5 through I50 based on Today's date in Cell E4. So, for next year's December 31st, I'd like to be able to see 26.5 in Cell C7. In the Sample Sheet, I've hard-coded the Date of Cell C5 into my VLOOKUP formula in Cell C7. I can't seem to be able to figure out how to increment Cell C5 when Cell E4 changes to a new December 31st in subsequent years.
Any help is appreciated. Please if you can, make changes to the attached Sample Sheet and re-post with your solution for my download.
Thanks