ExcelBanter - Help with a date formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with a date formula (https://www.excelbanter.com/excel-discussion-misc-queries/242071-help-date-formula.html)

fineline

Help with a date formula

Hi could someone help me out please, its probably a very simple formula but
too advanced for me.

In my cell A1 I have a date.

What i want to happen in cell B1, is when the date in A1 equals or exceeds
14 days the value 'OVERDUE' is returned.

Many Thanks in advance

Pete_UK

Help with a date formula

Try this in B1:

=IF(TODAY()-A1=14,"OVERDUE","")

Hope this helps.

Pete

On Sep 9, 9:58*am, fineline
wrote:
Hi could someone help me out please, its probably a very simple formula but
too advanced for me.

In my cell A1 I have a date.

What i want to happen in cell B1, is when the date in A1 equals or exceeds
14 days the value 'OVERDUE' is returned.

Many Thanks in advance

All times are GMT +1. The time now is 03:30 PM.