Formatting Cells to display Date: month/day/year

From: romanntiko (romanntiko.15n8hq_at_excelforum-nospam.com)
Date: 05/02/04 

Date: Sun, 2 May 2004 14:28:40 -0500

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/time***.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/