G
Guest
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.
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.