Help With Formula

[Guest]

On my spreadsheet I need to come up with due dates based
on the different between what I type in column "A" and Final Due Date.
At the top of my spreadsheet in cell C-1 I have my Final due date.
Down column "A" I enter how many days are left to final due date,
IE -120, etc. What I want is in column "B" each time I type a
value in coulmn "A" the resulting date to appear. I can manually type in
a formula down column "B" like =sum(C1+A5) and that gives me the correct
value but it takes to long, is there a Conditional Format that I could apply
to
the entire column or anyother way to get this done ?

Thanks - George

 

[Paul Lautman]

On my spreadsheet I need to come up with due dates based
on the different between what I type in column "A" and Final Due Date.
At the top of my spreadsheet in cell C-1 I have my Final due date.
Down column "A" I enter how many days are left to final due date,
IE -120, etc. What I want is in column "B" each time I type a
value in coulmn "A" the resulting date to appear. I can manually
type in
a formula down column "B" like =sum(C1+A5) and that gives me the
correct value but it takes to long, is there a Conditional Format
that I could apply to
the entire column or anyother way to get this done ?

Thanks - George

Put =C$1+A1 in cell B1 and then copy down.

 

[Sandy Mann]

If I understand you corrctly try:

=IF(A1="","",$C$1+A1)

and copy down column B using the fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk