LinkBack URL
About LinkBacks
I'm trying to figure out how to combine these two functions
=IF(I2>30,"YES","NO")
=DATEDIF(H2,NOW(),"YD")
Basically, I want to know if 30 days has past since the date entered. If it has past to output a Yes, if not, a No. Thanks in advance!
I'm trying to figure out how to combine these two functions
=IF(I2>30,"YES","NO")
=DATEDIF(H2,NOW(),"YD")
Basically, I want to know if 30 days has past since the date entered. If it has past to output a Yes, if not, a No. Thanks in advance!
Just combine your two conditions:
=IF(DATEDIF(H2,NOW(),"YD")>30,"yes","no")
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks