Relative Date formula

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
 
N

Nick Hodge

Bdunk

=A1+20

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date diffrence in days, weeks and months. 1
VBA Coding Help for Beginner 0
Constant date in one cell 1
Help with formula 5
Conditional format Column based on Week Date 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel - Wich Function should I use? 1
Formula to fill cells based on Date of Arrival and Date of Departure 1

Top