Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help With Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help With Formula
George wrote:
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help With Formula
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 with @tiscali.co.uk "George" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |