Formula [Solved/Closed]

Report
Posts
2
Registration date
Thursday April 6, 2017
Status
Member
Last seen
April 6, 2017
-
Posts
2
Registration date
Thursday April 6, 2017
Status
Member
Last seen
April 6, 2017
-
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.

1 reply

Posts
1890
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 3, 2021
142
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Thursday April 6, 2017
Status
Member
Last seen
April 6, 2017

Thank you, that worked

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!