How do I set up Reminders in an excel spreadsheet?

C

Chilli Mel

I'm trying to set-up a new spreadsheet in Excel for sales and servicing of
bikes, I want to have something to alert/remind me to contact people for when
their service is due?
 
F

Flintstone

There are plenty of things you can do, try conditional format wit
this.

=AND(A1-TODAY()>=0,A1-TODAY()<=30)

Or

Paste this into whatever cell, will returns days remaining from toda
until the specified date code that is in the formula.

=DATEDIF(NOW(),38779,"d")

Mat
 
Top