date formulas
 

Please help! I have given an example of part of the spreadsheet i am creating
to outline my queery:

Report in / Reply due
/
1 Sept 2005 / 1 Sept 05
4 Sept 2005 / 18 Sept 05
/ 14 Jan 00
/ etc,
/ etc,

I have entered the following formula in the 'reply due' column: B1 = A1 + 14
which calculates the date two weeks after the date in the 'report in' column.
When i drag the formula down so it applies the entire 'reply due' column the
cells automatically say 14 Jan 00. I want the formula to apply to the entire
'reply due' column so that when a date is entered in the 'report in' column
the 'reply due' date automatically appears. However, i want the 'reply due'
column to stay blank until the 'report in' date is entered. How can i acheive
this? Any help or direction will be much appreciated.

B1 =IF(A1<"",A1+14 ,"")

--
HTH

Bob Phillips

"dannyrich" wrote in message
...
Please help! I have given an example of part of the spreadsheet i am
creating
to outline my queery:

Report in / Reply due
/
1 Sept 2005 / 1 Sept 05
4 Sept 2005 / 18 Sept 05
/ 14 Jan 00
/ etc,
/ etc,

I have entered the following formula in the 'reply due' column: B1 = A1 +
14
which calculates the date two weeks after the date in the 'report in'
column.
When i drag the formula down so it applies the entire 'reply due' column
the
cells automatically say 14 Jan 00. I want the formula to apply to the
entire
'reply due' column so that when a date is entered in the 'report in'
column
the 'reply due' date automatically appears. However, i want the 'reply
due'
column to stay blank until the 'report in' date is entered. How can i
acheive
this? Any help or direction will be much appreciated.