IF formula to compare a date with current date and return result

0 votes

I'm trying to find a formula that will let me check a cell's value against the current date to see if it's greater than or equal to today's date and provide a written response like "late." Return another word or nothing if the field is empty.

There must be a way to read the data from the source cell since I've tried transferring the outcome from the source cell (O10) into another cell (Y10) and using an if statement, but this seems unnecessarily difficult. Look below. Additionally, it returns late if the cell is empty:

=IF(O10>Y10,"OVERDUE","NOT DUE")
Sep 26 in Others by Kithuzzz
• 20,660 points
62 views

1 answer to this question.

0 votes

You can enter the following formula in the cell where you want to see the Overdue or Not due result:

=IF(ISBLANK(O10),"",IF(O10<TODAY(),"Overdue","Not due"))
answered Sep 27 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How to take a screenshot of a current Activity and then share it?

For me, I captured and then shared ...READ MORE

answered Feb 8 in Others by Soham
• 9,670 points
57 views
0 votes
1 answer

How to get current time and date in Android

In order to get the current date ...READ MORE

answered Feb 23 in Others by Aditya
• 7,660 points
742 views
0 votes
1 answer

Compare two dates with JavaScript

 The Date object will do what you ...READ MORE

answered Feb 18 in Java by Rahul
• 9,680 points
114 views
0 votes
1 answer

Date difference: different results in Excel vs. Python

To calculate the date difference, we can ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
370 views
0 votes
0 answers

Query comparing dates in SQL

I have a table containing dates for ...READ MORE

Sep 12 in Database by Kithuzzz
• 20,660 points
85 views
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
67 views
0 votes
1 answer
0 votes
1 answer

Excel - IF Formula with a FIND

What about using mid() to see if ...READ MORE

answered Sep 27 in Others by narikkadan
• 37,660 points
60 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP