You probably use VLOOKUP() function to find exact matches in Microsoft Excel, but you can also find the closest value when you don't know the exact value.

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.