Relative Date formula

  • Thread starter Thread starter bdunk
  • Start date Start date
B

bdunk

I would like to add a date to a cell based on a date in another cell.
Example: If Cell A1 is 12/1/03 I would like cell B1 to display the
date 20 days after cell A1. IS this possible?

You people are the greatest.

Bdunk
 
Bdunk

=A1+20

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top