| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Long IF Statement | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement | New Users to Excel | |||
| How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Linear Mode
