Help with if statement.....
 

I am trying to create a time sheet for the 15th of the month through the end.
I have an empty column for the 31st (S). I want this header (S13) to be blank
if cell R7 does not contain */31/*. If R7 does contain */31/* I want the date
displayed in S13. Is this possible?

Help with if statement.....
 

The equation that I am trying (that is not working) in S13 is:
=IF(R7=*/31/*,=R7,"")

"WalterT." wrote:

I am trying to create a time sheet for the 15th of the month through the end.
I have an empty column for the 31st (S). I want this header (S13) to be blank
if cell R7 does not contain */31/*. If R7 does contain */31/* I want the date
displayed in S13. Is this possible?

Help with if statement.....
 

Now using IF(R7=(DAY(31)),R7,"" bit still no good. Please Help.

"WalterT." wrote:

The equation that I am trying (that is not working) in S13 is:
=IF(R7=*/31/*,=R7,"")

"WalterT." wrote:

I am trying to create a time sheet for the 15th of the month through the end.
I have an empty column for the 31st (S). I want this header (S13) to be blank
if cell R7 does not contain */31/*. If R7 does contain */31/* I want the date
displayed in S13. Is this possible?

Help with if statement.....
 

Hi Walter

Assuming R7 holds true Excel dates, then
=IF(DAY(R7)=31,R7,"")

Regards

Roger Govier


WalterT. wrote:
The equation that I am trying (that is not working) in S13 is:
=IF(R7=*/31/*,=R7,"")

"WalterT." wrote:


I am trying to create a time sheet for the 15th of the month through the end.
I have an empty column for the 31st (S). I want this header (S13) to be blank
if cell R7 does not contain */31/*. If R7 does contain */31/* I want the date
displayed in S13. Is this possible?

Help with if statement.....
 

You Rock! Thanks sooo much!

"Roger Govier" wrote:

Hi Walter

Assuming R7 holds true Excel dates, then
=IF(DAY(R7)=31,R7,"")

Regards

Roger Govier


WalterT. wrote:
The equation that I am trying (that is not working) in S13 is:
=IF(R7=*/31/*,=R7,"")

"WalterT." wrote:


I am trying to create a time sheet for the 15th of the month through the end.
I have an empty column for the 31st (S). I want this header (S13) to be blank
if cell R7 does not contain */31/*. If R7 does contain */31/* I want the date
displayed in S13. Is this possible?