Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formula
Greetings folks. Lets say in B1:M1 I have
"1/31/2008","2/29/2008"..."12/31/2008". Simply the last day of each month for 2008, as headers for the rest of the rows. In B2:M20000 I have integer values starting in various months. In A2:A20000 I want to calculate the date in row 1 minus an integer value, 120, I enter in A1 based on the first column for each row with a value entered. Let's say, for example, that in row 2 the first column where I have a value populated is G2, or June. What I need to do is have a formula subtract A1 from 6/30/2008. This would be easy, but the problem is that the first month I have a value populated varies for each row. I could have column K be the first month with a value, in which case I would need the formula to calculate 10/31/2008 - A1. Does this make sense? My layout is for scheduling jobs, and I need to calculate a material need date based on the start date. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming |