On Jan 22, 6:34*pm, "Jake" wrote:
I would like to take a date in A1 and in A2 have a set number of days from
that date. In A3 will be shown the date which is A2 days before/ahead of A1.

Example: A1 = 22-Jan-12, A2 = 5 and A3 will be calculated automatically as
27-Jan-12.

Obviously this is an oversimplified result, my idea is to calculate many
thousands of days ahead and before set specified dates.

EXCEL 2007

In A1 put the date.

In A2 put the number.

In A3 put:-
=A1+A2
- and it will display:-
27 January 2012