I have a maintenance schedule in excel split by quarter (1,2,3,4 etc). Along
the left-most column is worksite, Each quarter has a column, due on or before
and date completed column.

A B C D
E
SITE QTR1 QTR2
1 xxxx Due on/Before Completed Due on/Before Completed

I have a date in Qtr1 "due on/before" column. What I want to do is, I guess
it needs to be an IF statement for the date that goes in Qtr2 Due date such
as:

In D1... If the date in Completed Column(C1) blank, then C1 +91, else B1+91

Any Suggestions?

Maybe this........

=IF(C1<"",C1+91,B1+91)

Vaya con Dios,
Chuck, CABGx3




"Jcraig713" wrote:

I have a maintenance schedule in excel split by quarter (1,2,3,4 etc). Along
the left-most column is worksite, Each quarter has a column, due on or before
and date completed column.

A B C D
E
SITE QTR1 QTR2
1 xxxx Due on/Before Completed Due on/Before Completed

I have a date in Qtr1 "due on/before" column. What I want to do is, I guess
it needs to be an IF statement for the date that goes in Qtr2 Due date such
as:

In D1... If the date in Completed Column(C1) blank, then C1 +91, else B1+91

Any Suggestions?

Thanks is works beautifully!

I was using IF(C1"",C1+91,B1+91)

What does the < that the doesn't?

"CLR" wrote:


Maybe this........

=IF(C1<"",C1+91,B1+91)

Vaya con Dios,
Chuck, CABGx3




"Jcraig713" wrote:

I have a maintenance schedule in excel split by quarter (1,2,3,4 etc). Along
the left-most column is worksite, Each quarter has a column, due on or before
and date completed column.

A B C D
E
SITE QTR1 QTR2
1 xxxx Due on/Before Completed Due on/Before Completed

I have a date in Qtr1 "due on/before" column. What I want to do is, I guess
it needs to be an IF statement for the date that goes in Qtr2 Due date such
as:

In D1... If the date in Completed Column(C1) blank, then C1 +91, else B1+91

Any Suggestions?

if you had numbers you could have used 0
< means NOT equal to

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jcraig713" wrote in message
...
Thanks is works beautifully!

I was using IF(C1"",C1+91,B1+91)

What does the < that the doesn't?

"CLR" wrote:


Maybe this........

=IF(C1<"",C1+91,B1+91)

Vaya con Dios,
Chuck, CABGx3




"Jcraig713" wrote:

I have a maintenance schedule in excel split by quarter (1,2,3,4 etc).
Along
the left-most column is worksite, Each quarter has a column, due on or
before
and date completed column.

A B C D
E
SITE QTR1 QTR2
1 xxxx Due on/Before Completed Due on/Before
Completed

I have a date in Qtr1 "due on/before" column. What I want to do is, I
guess
it needs to be an IF statement for the date that goes in Qtr2 Due date
such
as:

In D1... If the date in Completed Column(C1) blank, then C1 +91,
else B1+91

Any Suggestions?

You're welcome, thanks for the feedback.........

< means "does not equal"
means "Greater than"

Vaya con Dios,
Chuck, CABGx3

"Jcraig713" wrote:

Thanks is works beautifully!

I was using IF(C1"",C1+91,B1+91)

What does the < that the doesn't?

"CLR" wrote:


Maybe this........

=IF(C1<"",C1+91,B1+91)

Vaya con Dios,
Chuck, CABGx3




"Jcraig713" wrote:

I have a maintenance schedule in excel split by quarter (1,2,3,4 etc). Along
the left-most column is worksite, Each quarter has a column, due on or before
and date completed column.

A B C D
E
SITE QTR1 QTR2
1 xxxx Due on/Before Completed Due on/Before Completed

I have a date in Qtr1 "due on/before" column. What I want to do is, I guess
it needs to be an IF statement for the date that goes in Qtr2 Due date such
as:

In D1... If the date in Completed Column(C1) blank, then C1 +91, else B1+91

Any Suggestions?