Creating a task in Outlook from a date in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure you can do this but what I have is a list of potential customers and
next action follow up dates in an excel spreadsheet. Can I apply a task
(within excel) to provide me a reminder to follow that enquiry up on that
specific date. A bit convoluted I know but it's how I am working.
Thanks for now
Jamie
 
=IF(cell_with_follow_up_date=TODAY(),"Time to follow up","")

now of course if you are not at the office/workplace etc during that day it
will go blank again the day after, so you might want to use


=IF(cell_with_follow_up_date<=TODAY(),"Time to follow up","")



you can also use conditional formatting and change the colour of the dates
that are due


=cell_with_follow_up_date<=TODAY()
 
Thanks for the links I will try and do some more digging. Any chance you
could play around and see if it is possible outside of your office hours.
It's cheeky I know but hey, if you don't ask.....
thanks anyway
 
Back
Top