Prev: Excel 2003 - Maximum number of characters a cell can contain?
Next: Macro to hide/unhide WS based upon WS tab color
From: Sanjeev on 8 Apr 2010 13:04
If an product is created on 5th of April and after 5 days i.e., on 10th of
April it is considered as out of standard what is the excel based formula i
can use..
From: Chip Pearson on 8 Apr 2010 13:07
Dates are just numbers (number of days since 0-Jan-1900) so you can do
simple subtractions. E.g,

=IF(TODAY()-DATE(2010,4,5)>=5,"Out Of Spec","OK")

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com


On Thu, 8 Apr 2010 10:04:01 -0700, Sanjeev
<Sanjeev(a)discussions.microsoft.com> wrote:

>If an product is created on 5th of April and after 5 days i.e., on 10th of
>April it is considered as out of standard what is the excel based formula i
>can use..
From: Eduardo on 8 Apr 2010 13:16
Hi,
you have the production dates on columnB and in C you want a formula to tell
you if product is out of standard , so enter

=IF(TODAY()-B2>10,"OUT OF STANDARD","")

copy formula

"Sanjeev" wrote:

> If an product is created on 5th of April and after 5 days i.e., on 10th of
> April it is considered as out of standard what is the excel based formula i
> can use..
 | 
Pages: 1
Prev: Excel 2003 - Maximum number of characters a cell can contain?
Next: Macro to hide/unhide WS based upon WS tab color