Can two arguments be entered in a formula? e.g.
=IF(D4>(C4+14),D4<(C4+14)"OVERDUE"," ")
I would like the formula to say overdue if it is over 14 days and nothing has been entered and not to say anything if a date is entered 14 days after the first date......can you help ;-)

Hi Lisa,

The IF function you are giving as an example doesn't work when you put in other arguments after operator. It is more straightforward, if this is true, for example, A1+B1=3 then........., if it is not true then............

What I suggest is =IF(B1-A1>14, "Overdue","") this will compare the dates and if it is more that 14 days old it will come out as overdue. So you can put in a formula but it must be before the operator.

Good luck

Tracy
Microsoft Excel training course instructor.

Hello Tracey,

The formula you give me is doing the same thing as the one I am currently using the problem I am having is that I want to incoperate into that formula another argument which will look at the current date and if it is 14 days and nothing has been entered in B1 then say overdue what is happending now it that formula is causeing things that is entered today to say overdue when it has not been sent as yet.......sorry :-)

lisa

Hi Lisa,

Sorry for the delay, here are a couple of things you could try. There is a function called =TODAY() which returns todays date each time you open excel. There is another function called DAYS360(C4,D4) where the result will be the amount of days between the date in C4 and the date in D4. Try that and perhaps use the if function on the result.

Let me know how you get on

Tracy