Formatting Cells to display Date: month/day/year

[romanntiko]

I am a newbie when it comes to Excel and after doing some searchin
through threads I couldn't find the exact answer I needed so her
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 se
the formula for dates so that the dates update automatically withou
having to change them manually every pay period. I hope that mak
sense.

Thank You

Danie

 

[Frank Kabel]

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

 

[romanntiko]

The link works, just tested it. Any one else having the same proble
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/0
instead of doing it manually each month.

Danie

 

[Gord Dibben]

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

 

[SidBord]

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)

 

[romanntiko]

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

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

Would attaching the file help?

Danie

 

[tsides]

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())).