If date in cell is greater than date in cell

Solved/Closed

Excel

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

Hello,

I am a beginner with formulas in Excel. I am working with dates formatted dd/mm/yyyy. I need a formula that will return a value of yes or no, if the date in cell A1 is before or after the date in cell B1.

Can someone help.

Thanks,
Mel

Excel formula if date is greater than another date
Excel formula if date is greater than another date highlight cell - Best answers
Excel formula if one cell is greater than another - Best answers
If cell contains date then return value ✓ - Office Software Forum
Count if cell contains number - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
If cell contains specific text then return value in another cell ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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"))

NHF
Nov 1, 2010 at 12:04 PM

I am using the formula to determine which deposit dates were late vs timely, and it is not calculating correctly. Can you help me determine why? Everything except for a blank E8 comes out "late".

=IF(E8>M8,"LATE",IF(E8=M8,"TIMELY",IF(E8<M8,"TIMELY")))

Similar discussions

How to convert number into text in Excel

Formula to Find&replace blank cells in excel

converting number into words (Excel)

formulas for 1st and 2nd position in class

Convert number to spelling

Counting number of times a value appears if..

Similar discussions

Subscribe To Our Newsletter!