Using+Today+Function+in+Excel

Using Today Function in Excel

If you wish your entries to have the current date entered when you use the sheet you have to do the following :‐

In A3 for example type ( without the quotes ) “ Today is :”

Then in A4 type “=Today “

You must start with the equals sign and end with the two brackets Now when Excel loads up today’s date is displayed in A4

If you now copy this formulae into all the “ A “ column ( You can do this by dragging the small square in the bottom right hand into the cells below )

Now whenever you enter data into a “ B “ column

The date will automatically be entered into the “ A “ column for you.