Excel Help?

Question

I am putting a date in a cell and I would like another cell to automatically calculate 90 days. What is the formula?

Thanks :-)

How do I copy that formula in other cells. For example M3, M4, M5, M6, etc...

Answer 1

Click on the cell you want to be 90 days from the date in the other cell:

Type "="
Click on the date cell
Type "+90"
Hit the Enter Key

Answer 2

This is an easy one. Put a formula in the other cell that refers to the first one and adds 90 to it!

e.g. if the date is in A1, then the formula would be

=+A1+90

Answer 3

Just do a simple addition using the date in the date format to get the answer in date format. For example if it was in A1 then do =A1+90. Date calculation HELP shows the technique.

Answer 4

if the date is in a1 then in b1 type =a1+90 then to copy and paste it, simply click on cell b1, press ctrl+c, select all of the cells that you want to paste the formula to and then press ctrl+v. the formulas will automatically update so that they are checking the cell to the left, meaning b2 would have =a2+90 and b45 would say =a45+90

Answer 5

try =(sumA1+90) assuming A1 is the cell with the older date in it.
Make sure A1 is formatted for date by clicking Format, Cell and Date and select the date format you would like to see.

I just tried this. It works.

Answer 6

Lets say the date is in a1
make the formula in a2 be =A1+90
make sure the format of a2 is in date format.

Answer 7

umm it's kinda hard to explain. Make sure the empty "box" hightlighted and press the Sum button located in the top it the screen, after type in +90 that should do it!!!

Answer 8

=a1+90

where a1 is the cell you are putting the date....