differences between 3

[dhealy]

I have 3 columns with dates in them with one column being the constant. I
need to find the number of days between the constant date and one column if
the other column is blank, if there is a date in the 3rd column then I need
to use that date with the constant. Help...

 

[Luke M]

Assuming column A if one columns, B is column that can be blank, and C is
your constant:

=IF(B2="",ABS(A2-C2),ABS(B2-C2))

The absolute function is included to cover both scenarios in which constant
could be less than or greater than date in A2/B2. Feel free to take it out if
you don't need it.

 

[Luke M]

Assuming column A if one columns, B is column that can be blank, and C is
your constant:

=IF(B2="",ABS(A2-C2),ABS(B2-C2))

The absolute function is included to cover both scenarios in which constant
could be less than or greater than date in A2/B2. Feel free to take it out if
you don't need it.

 

[Niek Otten]

Maybe:

=IF(C1="",B1-A1,C1-A1)

Format as number, not as date

 

[Niek Otten]

Maybe:

=IF(C1="",B1-A1,C1-A1)

Format as number, not as date

 

[Bill Kuunders]

one way

A1 is the constant date
B1 is normally used
C1 is sometimes blank

enter in D1

=IF(C1<>0,C1-A1,B1-A1)

 

[Bill Kuunders]

one way

A1 is the constant date
B1 is normally used
C1 is sometimes blank

enter in D1

=IF(C1<>0,C1-A1,B1-A1)

 

[dhealy]

Thanks Niek, that is exactly what I needed to achieve.
Enjoy your day,
deb

 

[dhealy]

Thanks Niek, that is exactly what I needed to achieve.
Enjoy your day,
deb

 

[dhealy]

Hi Luke,
thanks for your input but the formula didn't work out for the "sometimes"
columm I use. I have kept your formula for other worksheets that this will
fit into.
dhealy

 

[dhealy]

Thanks Bill,
for some reason I could not get the "sometimes" columm to adjust correctly
but thank you for your input. Your outcome could come in handy for me on
another worksheet.
Greetings from Michigan

 

[dhealy]

Hi Luke,
thanks for your input but the formula didn't work out for the "sometimes"
columm I use. I have kept your formula for other worksheets that this will
fit into.
dhealy

 

[dhealy]

Thanks Bill,
for some reason I could not get the "sometimes" columm to adjust correctly
but thank you for your input. Your outcome could come in handy for me on
another worksheet.
Greetings from Michigan