I have a formula working, but if K3 has a date in it and j3 is blank I get the serial of the date I want a blank in the cell
=IF(K3="",IF(J3<>"",IF(AND(DATEDIF(J3,TODAY(),"d")>=7,K3=""),"Chase Up",""),""),DATEDIF(J3,K3,"d"))
Thank you for any help
I have a formula working, but if K3 has a date in it and j3 is blank I get the serial of the date I want a blank in the cell
=IF(K3="",IF(J3<>"",IF(AND(DATEDIF(J3,TODAY(),"d")>=7,K3=""),"Chase Up",""),""),DATEDIF(J3,K3,"d"))
Thank you for any help
Last edited by UltimateNeo; 09-22-2019 at 11:48 AM.
You should really change your thread title, to make it describe what you want to achieve - see Rule 01 of the Forum Rules at the top of the screen.
Pete
How about
=IF(J3="","",IF(K3="",IF(DATEDIF(J3,TODAY(),"d")>=7,"Chase Up",""),DATEDIF(J3,K3,"d")))
Ultimate Neo. You've been here for a while and have lots of posts. By now, you should realise that your title is too weak. If you had been doing a Google search for an answer.... what search term would you have used? That's what we expect to see, not your chosen title, which would yield a squillion useless hits.
Normally, I would lock the thread down and require you to make the change yourself. However, since you may already have an answer, that seems a bit pointless. However, do please take a moment to come up with a better title and change the thread title YOURSELF. If the answer is not what you need and you do not change the title, I WILL lock the thread UNTIL you make a suitable change.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
UltimateNeo... thanks for making the change.
@UltimateNeo
Thanks for the Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks