Excel function help

**Xk5** · 12-18-2014, 07:58 PM

Hello everyone, new at the forum. I need a bit of help with a problem that i am running and cant seem to figure it out. I am working on a production schedule for work. I have it set up where a user enters all the info for a new po and i have a column named status it compares the due date to today() and it displays a message if the order is on time or late =if(d2<today(), "on time", if d2>today(),"late")) this function seems to work fine now what i want to do is add another function to the same cell (status)that once i enter a date on the shipped date column it overwrites the function above. I dont know how to proterize funcions while my shipped date is blank or 0 the above function is being executed but as soon as i enter a date i would like the to compare due date with shipped date and dissplay a message instead of the function above that it compares the due date with today()
How do i tell it that while shipped date is blank or 0 compare due date with today() but as soon as i enter a shipped dated compare the due date with shipped date culomns ,
I hope i am making sence lol
Anyone that could help me i would really appreciate it
Thank you

**FDibbins** · 12-18-2014, 09:12 PM

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(Consider adding another IF statement, your wording (How do i tell it that ...) pretty much answered your own question)