changing dates

[gray78]

I currently use the same workbook every day which has a worksheet for each day in the month. Is there a way to change the date (in a particular cell)on each page (for the current month) without having to do it manually? The tab for each day also has a date and I would like to change this as well.

Thanks for the help

Gray 78

 

[AnotherHiggins]

I would very strongly suggest you consider restructuring your data. It is a very bad idea to have your data set broken down across 30 tabs for one month's data.

In the long run, you'll make your own life *MUCH* easier by normalizing your data - using the date as a column.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[gray78]

unforunately this is the way the boss whats it. I would like to be able to change the dates from February (i.e. 2/1/2006 etal) to March (i.e. 3/1/2006 etal)

Gray 78

 

[bkpchs237]

gray78,
anotherhiggins makes an excellent point. However, we all understand "Bosses." Enough said.
You can find the current month using =month(today()). Or use the formula =DATE(YEAR(TODAY()),MONTH(TODAY()),1) in the first worksheet which will obtain the first day of the current month.
However, it would be best for you to place the date of the first of the month into a particular cell on the first worksheet. Then the other worksheets in succession could have a cell that adds one to the cell with the date of the previous worksheet. After the initial setup of all 31 sheets they would all have the appropriate date. The advantage of this is that you could copy the workbook and need to only change one cell on one worksheet for the new month.

Hope this helps.

 

[SkipVought]

Hi,

I wholeheartedly agree with anotherhiggins.

Your boss is obviously not a person who understands data storage, data analysis and data reporting principles.

Most spreadsheet users think in terms of what looks good in terms of reporting rather than what makes sense and is considered "best practice" for data storage.

What would happen if your boss' boss asked him/her to analyze and report on some aggregate of the stored data, like year-to-date or month-to-date. It would be EXTREMELY difficult and time consuming. If your data were stored as John suggested, you could produce a DAILY, WEEKLY, MONTHLY, "whatever" report in SECONDS, using many of Excel's data reporting features.

Get you boss to read this entire thread.

Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}