Formula with date range tolerance

Good Evening,

First post so please be gentle.

I'm trying to write a formula for comparing an expiry date with the TODAY function and a 14 day +/- tolerance.

I need A4 to display the word "contact" if the date in H4 is + or - 14 days from todays date and for the cell to be blank if its outside the +/- 14 days.

This sheet effectively needs to show all contracts that are either over 14 days expired or due to expire in 14 days from the date the sheet is looked at on a rolling basis.

I've spent ages trying to work it out and completely boggled my brain, i'm sure its easy but i cannot figure it out.

Can anyone help me please?

Thanks
Peter

Brilliant, thanks. i see how you did that.

I have one more question if i may.

If i wanted to have a further 12 sheets in the same workbook, one for each month, and i wanted to display the whole row in a seperate sheet if the date was anytime in january, how would i formulate that?

i.e.

sheet titled data

Cell I5 has the contract expiry date and if it was any date in January i would want to populate that entire row into a sheet titled Jan. If i cannot do the row as a whole then how would i transfer the data from 'data!' sheet cell I5 to 'jan!' sheet cell I5.

I hope that makes sense but i basically need to transfer the the data to a new sheet for the month the contract expires in.

Thanks again for your help.

Hi,


I need to generate automatic serial no for drop down records which I have, Since there is a huge data I feel difficult to enter

manually.Some one pl help to solve this issue. Sample data enclosed below.


DATA

Country Suggestions list Drop Down List Serial Number

United States United States United States 1
China United Kingdom
Japan
Germany
France
Brazil
United Kingdom

Rgs

Silambu