Report

Formula [Solved]

Ask a question ehmetcalf 2Posts Thursday April 6, 2017Registration date April 6, 2017 Last seen - Last answered on Apr 6, 2017 at 12:33 PM by ehmetcalf
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 
Helpful
+1
plus moins
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 2Posts Thursday April 6, 2017Registration date April 6, 2017 Last seen - Apr 6, 2017 at 12:33 PM
Thank you, that worked
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!