Excel Question

By aj303 ·
i am making a excel sheet and i want to update the dates automatically everyday.
What is the formula for this........???

like i have 30 my excel sheet..that 30 rows contains the data of the past 30 what i am looking for is.... I want to update the for 30 rows by last 30 days date....Is there any formulae we can write on first colum and then we can drag the rest of the rows and put fill series so that we can get all colums filled in with the last 30 days date......just as like we do and fill S No: in colums.....

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Date arithmetic

by oldbaritone In reply to Excel Question

A1: =Now()
A2: =A1-1
A3: =A2-1
A4: =A3-1

The first cell gives the initial date value.
After that, just subtract "1" from the previous cell.
Highlight A2, Copy-and-drag to A3-whatever

Related Discussions

Related Forums