Checking A Date (Greater or Less)

**Andrew.Trevayne** · 01-20-2017, 12:45 PM

Hi all,
On my column A is a bunch of dates.
I would like to ask for a formula to do something like this.

If Date is > than today it will give me Yes as Result.
If Date is = today it will give me Yes as Result.
If Date is < than today it will give me No as Result

Any help will be greatly appreciated. Thank you.

**Tony Valko** · 01-20-2017, 12:47 PM

Like this...

=IF(A1>=TODAY(),"Yes","No")

Copy down as needed.

**Andrew.Trevayne** · 01-20-2017, 12:50 PM

Thank you so much for the quick response. Much appreciated.

**Tony Valko** · 01-20-2017, 12:52 PM

You're welcome!

Checking A Date (Greater or Less)

LinkBack

Thread Tools

Rate This Thread

Display

Checking A Date (Greater or Less)

Re: Checking A Date (Greater or Less)

Re: Checking A Date (Greater or Less)

Re: Checking A Date (Greater or Less)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] checking if a date/date range already exists in 4 other date storing tables

Checking if date value in cell is between or equal to start and end date

[SOLVED] VBA Macro to Color Row Text If Date in Cell is greater than system date

[SOLVED] Checking to see if a date is within current month from a column of date values using vba

[SOLVED] Macros for: If Today's Date minus other date is greater than certain amount of days Then

Find a date less or greater than a particular date from a range of cells

Formula to check if date is greater than or equal to current date

Bookmarks

Bookmarks

Posting Permissions