Question

Locked

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 rows....in my excel sheet..that 30 rows contains the data of the past 30 days......now 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.

1 total post (Page 1 of 1)  
| 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

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums