Formula [Solved/Closed]

ehmetcalf 2 Posts Thursday April 6, 2017Registration date April 6, 2017 Last seen - Apr 6, 2017 at 11:35 AM - Latest reply: ehmetcalf 2 Posts Thursday April 6, 2017Registration date April 6, 2017 Last seen
- Apr 6, 2017 at 12:33 PM
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day.

I have a column with maturity dates, I have a column I want to show Matured. So if the date is today or less than it should show matured in the column or be blank.

=IF(G3<="TODAY","MATURED","")
=IF(G3>="TODAY","","MATURED")

Everything shows up Matured. Thanks for any help you can give me.
See more 

2 replies

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Apr 6, 2017 at 12:10 PM
+1
Helpful
ehmetcalf, Good morning.

The "today" function of excel must be written as TODAY() without the apostrophes.
Only that.

Try to use:

=IF(G3<=TODAY(),"MATURED","")

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
ehmetcalf 2 Posts Thursday April 6, 2017Registration date April 6, 2017 Last seen - Apr 6, 2017 at 12:33 PM
Thank you, that worked