Your post is quite vague could you please clarify.

Lisa wrote:
I need a formula or macro that can do the following. Enter start date and #
of years of contract terms, macro or formula will show the complete details
in the spreadsheet.