application development excel - Creating formulas

Hi Lisa,

I would use the IF function, it compares two values in your case two dates and can give text responses.

=IF(B1-A1>14, "Overdue", " ") would be one way to do this. Where A1 and B1 have dates in them. It translates to IF the second cell minus the first cell is bigger than 14 then to show the word "Overdue" and it this is not the case to show nothing. This formula can be copied down the column.

Formulas deal with cell references, values and operators such as + - * / a tick being a symbol is not used. What type of thing did you want to do?

Tracy

Hi Lisa

Thanks for your question.

This could be handled by using the IF function to determine if the difference between two different dates then enter "overdue" if there is more than 14 days difference between the two dates.

If the first date is in column A and the second date is in column B, then the formula would look like this:
=IF((B?-A?)>14,"overdue","")

where ? represents the row number.

You refer to the current date in your question as well - I'm not sure how this fits in with what you want to be able to do, but if you enter =today() into a cell this will give you the current date, then you could use the cell that has the current date in it as part of the formula provided above.

To my knowledge, trying to use a symbol in a formula does not work particularly well - I don't think you can insert a symbol directly into a formula and if you try inserting a symbol then copying and pasting it into a formula this doesn't seem to work either.

I hope this helps to answer your question.
Amanda