# Formula values not updating excel vanessa lengies dating jamie waylett

This is what surprises me, because the *formula* is exactly the same with the 2 methods.I want to cover something today that I use all of the time but seems to be understood in varying degrees by clients I work with.So, I copied the cell F37 using Ctrl C and pasted it to the rest of the row using Ctrl R (fill right).

In each case it is changing the reference to refer to the cell one to the left on the same row as the cell that the **formula** is in, i.e.

the same relative position that A1 was to the original **formula**.

We tried using the Calculation shortcuts, including Ctrl Alt Shift F9 (that one recalculates everything, and starts your car).

Syntax of DATE **Formula** Example of DATE **Formula** Possible Errors returned by the DATE **Formula** DATE **formula** in **Excel** returns the number representing the date for a given day, month and year.

I am copying the two **formulas** (dragged & copied) below to show that they are identical.

## Community Discussion