Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Required
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB help required | Excel Discussion (Misc queries) | |||
Help Required 4 | Excel Programming | |||
VBA Help required..........! | Excel Programming | |||
Help required | New Users to Excel | |||
Vba Help Required | Excel Programming |