If date in cell is greater than date in cell
Solved/Closed
Mel
-
Mar 4, 2010 at 08:46 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 2, 2010 at 11:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 2, 2010 at 11:06 AM
Related:
- Excel formula if date is greater than another date
- Excel if greater than date - Best answers
- Excel if cell contains date - Best answers
- If cell contains date then return value ✓ - Office Software Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 5, 2010 at 03:47 AM
Mar 5, 2010 at 03:47 AM
Use IF statement
'yes if date 1 is not equal to day 2
=IF(A1<>B1, "YES", "NO")
'to show you use of nested if
=IF(A1>B1, "YES, A1>B1, IF(A1=B1, "YES, A1=B1, "Default A1 < B1"))
'yes if date 1 is not equal to day 2
=IF(A1<>B1, "YES", "NO")
'to show you use of nested if
=IF(A1>B1, "YES, A1>B1, IF(A1=B1, "YES, A1=B1, "Default A1 < B1"))
Nov 1, 2010 at 12:04 PM
=IF(E8>M8,"LATE",IF(E8=M8,"TIMELY",IF(E8<M8,"TIMELY")))