ExcelBanter - Help Required

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help Required (https://www.excelbanter.com/excel-discussion-misc-queries/450887-help-required.html)

Hi Team,

Need ur help as I got stuck up in a place.

In a sheet, i have following details

Cell A1 = Due Date e.g. 19-May-2015
Cell B1 = Require a formula which would display Reminder in the cell 10 Days Before.

Thanks in Advance.

Best Regards

Akash Maheshwari
Handheld: +918588801007

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