K
kfcgirly
I want to show dates fortnightly in my columns. Is there a formular of some
kind to allow me to do this?
kind to allow me to do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave F
Put the start date, say 8/17/06 in one cell, say A1.
In the next cell, put =A1+14 and fill down.
In the next cell, put =A1+14 and fill down.
K
kfcgirly
That just made it say #VALUE!
Dave F said:Put the start date, say 8/17/06 in one cell, say A1.
In the next cell, put =A1+14 and fill down.
D
Dave F
make sure the cells are formatted as dates.
It works for me.
It works for me.
D
Dave Peterson
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.
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.