Using Dates with true and false statements
 

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!

Using Dates with true and false statements
 

Hi,

=if(AI4="","",IF(TODAY()-AI45,"Yes",""))

"Princess V" wrote:

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!

Using Dates with true and false statements
 

Sorry...I forgot one piece of my question....

let me try again.

I have a date value in Colum AI....
I have another column with another date in Column AK.

If today minus the the date in Column AI is 5 and Column AK is blank -
then return Yes in the Overdue Column (Column AO).

Is this doable?

"Princess V" wrote:

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!

Using Dates with true and false statements
 

Sorry, I posted the second half of my question in an additional post right
under the original.

Is there a way that I can take this formula one step further to say:

If Today minus AI4 is 5 and column AK is blank....then return a Yes in the
Overdue Column?




"Eduardo" wrote:

Hi,

=if(AI4="","",IF(TODAY()-AI45,"Yes",""))

"Princess V" wrote:

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!

Using Dates with true and false statements
 

Hi,
=IF(and(TODAY()-AI45,AK4=""),"YES","")

if the bothe conditions are not true will enter a blank

"Princess V" wrote:

Sorry...I forgot one piece of my question....

let me try again.

I have a date value in Colum AI....
I have another column with another date in Column AK.

If today minus the the date in Column AI is 5 and Column AK is blank -
then return Yes in the Overdue Column (Column AO).

Is this doable?

"Princess V" wrote:

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!

Using Dates with true and false statements
 

=IF(AND(AI4<"",AK4="",TODAY()-AI45),"Yes","")

If this post helps click Yes
---------------
Jacob Skaria


"Princess V" wrote:

Sorry, I posted the second half of my question in an additional post right
under the original.

Is there a way that I can take this formula one step further to say:

If Today minus AI4 is 5 and column AK is blank....then return a Yes in the
Overdue Column?




"Eduardo" wrote:

Hi,

=if(AI4="","",IF(TODAY()-AI45,"Yes",""))

"Princess V" wrote:

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!

Using Dates with true and false statements
 

This works perfectly except for one scenario:
- if column AI or AK are blank....it still shows as a YES. Shouldn't it
show blank unless dates are entered?


"Eduardo" wrote:

Hi,
=IF(and(TODAY()-AI45,AK4=""),"YES","")

if the bothe conditions are not true will enter a blank

"Princess V" wrote:

Sorry...I forgot one piece of my question....

let me try again.

I have a date value in Colum AI....
I have another column with another date in Column AK.

If today minus the the date in Column AI is 5 and Column AK is blank -
then return Yes in the Overdue Column (Column AO).

Is this doable?

"Princess V" wrote:

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!

Using Dates with true and false statements
 

Hi
As per your previous post you wanted the condition if today-AI5 and
AK=blank, to return Blank I can Add if AI is blank

=if(AI4="","",IF(and(TODAY()-AI45,AK4=""),"YES",""))

"Princess V" wrote:


This works perfectly except for one scenario:
- if column AI or AK are blank....it still shows as a YES. Shouldn't it
show blank unless dates are entered?


"Eduardo" wrote:

Hi,
=IF(and(TODAY()-AI45,AK4=""),"YES","")

if the bothe conditions are not true will enter a blank

"Princess V" wrote:

Sorry...I forgot one piece of my question....

let me try again.

I have a date value in Colum AI....
I have another column with another date in Column AK.

If today minus the the date in Column AI is 5 and Column AK is blank -
then return Yes in the Overdue Column (Column AO).

Is this doable?

"Princess V" wrote:

I have a spreadsheet that has a column that contains the date a particular
item was shipped.

I want to be able to identify (not with colours) those rows in which todays
date minus the date in the cell is greater then 5 days. If so, I want to
enter the value "Yes" in another column (title of column is Overdue because
its been greater then 5 days).

I have used: =IF(TODAY()-AI45,"Yes","")

The problem is, if the date column is blank, it still returns a Yes value.

How can I avoid this? I want it to either remain blank, or state No.

Help!