How do a lay out an EXCEL IF statement using DATES?

October 9, 2017 at 09:42:30
Specs: Windows 10
I want to have an IF true/false statement stating that for a column of DATES, if the date is before "5/1/2013" TRUE and everything else false within the if statement.

thank you in advance!


See More: How do a lay out an EXCEL IF statement using DATES?

Reply ↓  Report •

#1
October 9, 2017 at 10:03:45
Try this:

With your column of DATES in column A,
put this formula in cell B1 and drag down.

=IF(A1<DATE(2013,5,1),"True","False")

What happens if the date is exactly 5/1/2013?

See how that works for you.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •
Related Solutions


Ask Question