How to see if a particular cell in a table has date data or not
Solved/Closed
vinaymaithani
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014
-
Apr 14, 2014 at 04:19 AM
vinaymaithani Posts 4 Registration date Monday April 14, 2014 Status Member Last seen April 17, 2014 - Apr 16, 2014 at 12:51 AM
vinaymaithani Posts 4 Registration date Monday April 14, 2014 Status Member Last seen April 17, 2014 - Apr 16, 2014 at 12:51 AM
Related:
- How to see if a particular cell in a table has date data or not
- How to delete a row in a table in word - Guide
- Tmobile data check - Guide
- School time table software free download full version - Download - Organisation and teamwork
- If cell contains date then return value ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 14, 2014 at 11:35 AM
Apr 14, 2014 at 11:35 AM
Hi Vinay,
Let's assume the dates are located in A2:A5.
=IF(A5="",TODAY()-A4,TODAY()-A5)
Best regards,
Trowa
Let's assume the dates are located in A2:A5.
=IF(A5="",TODAY()-A4,TODAY()-A5)
Best regards,
Trowa
Thanks Trowa for the response.
How about If the formula can be made suitable for having data in any of the cell like say...
If data is present say A2 and A3 and not in A4 and A5 Then how the formula should be.
If data is present A2, and not in others A3, A4 and A5.
I tried nested IF but I messed it up every time.
Please help.
Regards
How about If the formula can be made suitable for having data in any of the cell like say...
If data is present say A2 and A3 and not in A4 and A5 Then how the formula should be.
If data is present A2, and not in others A3, A4 and A5.
I tried nested IF but I messed it up every time.
Please help.
Regards
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 15, 2014 at 10:20 AM
Apr 15, 2014 at 10:20 AM
Hi Vinay,
Then the formula would look like:
=IF(A2="","",IF(A3="",TODAY()-A2,IF(A4="",TODAY()-A3,IF(A5="",TODAY()-A4,TODAY()-A5))))
Best regards,
Trowa
Then the formula would look like:
=IF(A2="","",IF(A3="",TODAY()-A2,IF(A4="",TODAY()-A3,IF(A5="",TODAY()-A4,TODAY()-A5))))
Best regards,
Trowa
vinaymaithani
Posts
4
Registration date
Monday April 14, 2014
Status
Member
Last seen
April 17, 2014
Apr 16, 2014 at 12:51 AM
Apr 16, 2014 at 12:51 AM
Thank you Trowa D.
You are the Guru for me now.
You are genius. May God shower with more time to live & help people and enjoy what you wanna do in life.
Cheers.
Vinay
You are the Guru for me now.
You are genius. May God shower with more time to live & help people and enjoy what you wanna do in life.
Cheers.
Vinay