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

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?

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?

make sure the cells are formatted as dates.

It works for me.

"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?

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