Entry data in Excel

  belayer 11:51 08 Oct 2007
Locked

I have constructed a large spreadsheet file which I use, it is extremely complex but works well. I record the details about a lot of other files and include in one column the date when each one is updated.

Is there any way of asking Excel to compare the entry date with today's date and to let me know that (for example) one years has passed, or six months since it was updated?

Thanks

  silverous 12:31 08 Oct 2007

It depends on how you want it to let you know.
For example you could add another column (if you make sure the analysis toolpak is loaded) which does this:

=IF(EDATE(A1,6)<=TODAY(),"6MTH WARNING","")

Then alongside each file which hasn't been updated for 6 months will have the warning alongside. If you want Excel to hunt these down and warn you you probably want some VBA/A Macro which is also possible.

Let us know exactly what you want it to do.

  silverous 12:32 08 Oct 2007

(I'm assuming that A1 is the last updated date and that you copy this down an entire new column)

  belayer 14:01 08 Oct 2007

OK, thanks, I will play with that and see if its what I want, it sounds like its ideal.

  belayer 14:17 08 Oct 2007

I have a problem with loading the 'Analysis toolpack'. When I want to install it I get a box telling me to install the disck, but I only have the copy of windows that came with the PC when I bought it ready installed, no disks.

I will try the microsoft website, unless you know how alse I can get it.

  belayer 14:42 08 Oct 2007

I found the disks and have installed the Analysis toolpack,( I think, not sure how I check but it seemed to do it).

All I get is the warning words "6MTH Warning" regardless of the date I install in the cell it refers to (A1 in your example).

The idea that the second column alongside an out of date file just lights up with 'UPDATE' as appropriate would be great, even better if it said 'Current' when it doesn't need updating.

  belayer 15:10 08 Oct 2007

Its OK, got it working, its good thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Microsoft Surface Book 2 hands-on review – bigger and 5x faster

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?