Is there a way I can get Excel to shout at me if a date passes?

Is there a way I can get Excel to shout at me...

Didn't find your answer?

Lazy I'm sure, but what my vision involves is an Excel spreadsheet for CT that, if I put the year end date in, it will complete the deadlines (that bit I can do) and remind me that a deadline is coming up unless I tick a box or fill in a date or something?

I imagine I could set something up that changes the colour of a cell depending on how close the date in the cell next to it is (via conditional formatting) but I'd like to go one further and actually have my pc scream at me if we, for example, send out a CT600 and haven't had it back by a month before the submission date.

My Outlook calendar can handle the reminders if push comes to shove, but I want it all centralised and not to have to put dates in twice :)

Don't suppose I can link the Outlook reminder system to Excel?
Thomas Peterson

Replies (2)

Please login or register to join the discussion.

avatar
By listerramjet
13th Feb 2009 13:30

why not!
assuming you have table like data you could add a column with a formula that compares =now() (which is today's date) with the deadline date and flags those within say 30 days - say

=if(deadline-now()<=30,"FallingDue","OK")

then you could autofilter on FallingDue.

If you wanted something slightly more sophisticated you could add an owner (and owners email address) to each client, and use VBA to write an email to each owner with their falling due lists. To automate that you could get the VBA to autorun when the spreadsheet is opened, and you could use a scheduler to open the spreadsheet, and hence run the code, overnight, so the emails were delivered to inboxes first thing.

Thanks (0)