Notify if the date expires in Excel DB

[eXtremer]

Hi all.

There is a excel database with columns, there is a column with dates and I need to be notified by excel somehow that it past for example 30 days from that date, is it possible to implement such a thing in excel ? I need to be notified just once, after that to click on it and the reminder has to be set OFF.

I really need to find a workaround.

Thank you in advance.

 

[eXtremer]

Weird! They look the same - apart from the fact that I used A1 and you used A14.

Does that formula work if you put it in a worksheet cell?

No it doesn't, both formulas you gave me don't work, maybe in Excel 2003 the formula should different ?

 

[eXtremer]

Screenshot *.bmp
Screenshot *.png
Screenshot *.tif

 

[Ruddles]

I'm back at work and that site is blocked by the company firewall.

Your date isn't in A1 though, is it? Make sure you're formatting a cell in column N where your dates are and that the formula refers to the same cell. Just get it working on one cell to start with.

As for the differences between 2003 and 2007, I thought worksheet formulae were identical, so I can't imagine why it isn't working for you. Perhaps you can get someone who's familiar with 2003 to try the same formula?

 

[eXtremer]

The formula is wrong, can't test it...

The Formula you typed contains an error.


When I press enter, it highlights the ",A1"

=AND(A1>TODAY(),A1<(TODAY()+10))

Try Link1
Try Link2
Try Link3

 

[Ruddles]

What country are you in? Do you use semicolons as list separators?

Try semicolons instead of commas.

 

[eXtremer]

Thank Ruddles for your support, still can't get the "colour" thing working, but it's not a big problem.
Take care.

 

[Ruddles]

Okay, well if you change your mind you could try:-

=AND(A1>TODAY();[COLOR=black]A1[/COLOR]<(TODAY()+10))