Formatting Cells to display Date: month/day/year

I am a newbie when it comes to Excel and after doing some searching
through threads I couldn't find the exact answer I needed so here
goes:

[image: http://www.geocities.com/danmann81/timesheet.jpg]


The red box is the area I'm trying to format. What I want to do is set
the formula for dates so that the dates update automatically without
having to change them manually every pay period. I hope that make
sense.

Thank You

Daniel


---
Message posted from http://www.ExcelForum.com/

Hi
your link does not work :-)
You may try to avoid attachments/links and describe your issue in plain
text

--
Regards
Frank Kabel
Frankfurt, Germany


I am a newbie when it comes to Excel and after doing some searching
through threads I couldn't find the exact answer I needed so here
goes:

[image: http://www.geocities.com/danmann81/timesheet.jpg]


The red box is the area I'm trying to format. What I want to do is
set the formula for dates so that the dates update automatically
without having to change them manually every pay period. I hope that
make sense.

Thank You

Daniel


---
Message posted from http://www.ExcelForum.com/

The link works, just tested it. Any one else having the same problem
viewing?

What I want to do is set my dates, Ex:

4/5/04
4/6/04
4/7/04
4/8/04
4/9/04
4/10/04

with a formula so that they update auto when I change say 4/5/04
instead of doing it manually each month.

Daniel


---
Message posted from http://www.ExcelForum.com/

Enter a date in A1

In A2 enter =A1 + 1

Select A2 and drag/copy down column A

The only date you have to change is the one in A1. The rest will follow.

Gord Dibben Excel MVP

On Mon, 3 May 2004 00:07:28 -0500, romanntiko
wrote:

The link works, just tested it. Any one else having the same problem
viewing?

What I want to do is set my dates, Ex:

4/5/04
4/6/04
4/7/04
4/8/04
4/9/04
4/10/04

with a formula so that they update auto when I change say 4/5/04
instead of doing it manually each month.

Daniel


---
Message posted from http://www.ExcelForum.com/

I'm not sure I understand the problem, but the previous
reply using relative dates will work well. Do you want the
first date to change automatically too?
You might realte it to Month().
If Month(FirstDate) Month(Today()) _
Then . . . (Change the first date logic)
-----Original Message-----
Enter a date in A1

In A2 enter =A1 + 1

Select A2 and drag/copy down column A

The only date you have to change is the one in A1. The
rest will follow.

Gord Dibben Excel MVP

On Mon, 3 May 2004 00:07:28 -0500, romanntiko
wrote:

The link works, just tested it. Any one else having the
same problem
viewing?

What I want to do is set my dates, Ex:

4/5/04
4/6/04
4/7/04
4/8/04
4/9/04
4/10/04

with a formula so that they update auto when I change say
4/5/04
instead of doing it manually each month.

Daniel


---
Message posted from http://www.ExcelForum.com/

.

If you view the screen shot, all I want to do is have the dates update
automatically.

So if its 4/30/2004, I want it to update to 5/30/2004 if necessary.

Would attaching the file help?

Daniel


---
Message posted from http://www.ExcelForum.com/

When the dates update automatically, what value would you like them to
have? We need that in order to give you an answer. Also, I could not
get the link to your screen shot to work either.

Anyway, don't forget that you can put an =TODAY() function in a cell
to get the spreadsheet to automatically always tell you the current
day. If you want your dates to be calcualated based ont eh current
date, then you can use taht cell. Also, there are MONTH(), DAY(), and
YEAR() functions that you can use to read that portion of a date, such
as the month portion of today: =MONTH(TODAY()) or to build a specific
date, such as today's date plus a month:
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())) .