Good Afternoon,
I have the formula below:
Which works perfectly. If the date in Cell J2530 is before todays date, it shows up as todays date.
Please Login or Register to view this content.
Now, my problem begins, I need to run the same formula, but also have it so that if the word "DUE" is in Cell H2530 it reads todays date.
I have the bodged the formula below, but alas it doesnt work.
Can anybody assist in making the magic happen
Many ThanksPlease Login or Register to view this content.
Ross
Let's try
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this. might be what you need:
=IF(ISBLANK(J2530),"",IF(OR(J2530<TODAY(),H2530="due"),TODAY(),J2530))
http://www.ExcelbyJoe.com
Lol, wow answers come fast in this forum while figuring out an answer!
Both worked.
Thanks both!!!
Greatly Appreciated!
Can the code be altered for the Cell to be blank if H2517 contains "PROFORMA" "TBC" OR "YES"
ThanksPlease Login or Register to view this content.
Ross
Maybe this...
=IF(OR(H2517={"PROFORMA","TBC","YES"},J2517=""),"",IF(OR(H2517="DUE",J2517<TODAY()),TODAY(),J2517))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks