Make sure you match the same month, day, year order as your windows short date
when you type in your date.

8/17/06 will mean m/d/y (august 17, 2006) for me with my typical USA settings.

Maybe you need:
17/8/06

Match the format you get when you type ctrl-; (control-semicolon) in an empty
cell.

kfcgirly wrote:

That just made it say #VALUE!

"Dave F" wrote:

Put the start date, say 8/17/06 in one cell, say A1.

In the next cell, put =A1+14 and fill down.

"kfcgirly" wrote:

I want to show dates fortnightly in my columns. Is there a formular of some
kind to allow me to do this?

--

Dave Peterson