QUESTION

Can I convert a number to a date? For example one has 82 days left, is there a formula that will start from today's date and give me the date in 82 days?

ANSWER

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+82)