Help Required
Hi Akash,
Am Mon, 18 May 2015 21:55:37 -0700 (PDT) schrieb Akash Maheshwari:
Cell A1 = Due Date e.g. 19-May-2015
Cell B1 = Require a formula which would display Reminder in the cell 10 Days Before.
you could color cell A1 with conditional formatting using this formula:
=AND(A1=TODAY(),A1<=TODAY()+10)
Or you try in B1:
=IF(AND(A1=TODAY(),A1<=TODAY()+10),A1-TODAY()&IF(A1-TODAY()=1," day "," days ")&"left","")
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|