Formula for calculating the diffrence between two dates
 

suppose i have an product name as A001234-01APR10 which expires after 5
business days that is on 07th apr.. so It should give, on 3rd apr what is its
age and on 8th showing as expired..
what will be the excel based formula for this...

Formula for calculating the diffrence between two dates
 

I'll give you the main tool.
In order to calculate the working days (Mon-Thu) between two dates use:
=NETWORKDAYS(A1,A2) [where A1 has earliest date, B1 has latest date]
I would suggest to use this function - with an appropriate check - to
declare Conditional Format in coloring the cell when Expired.
Same Function can be used to present the "age"
*** For the NETWORKDAYS to operate - install the Analysis Toolpak ***
['Tools' 'Add-ins']
Micky


"Sanjeev" wrote:

suppose i have an product name as A001234-01APR10 which expires after 5
business days that is on 07th apr.. so It should give, on 3rd apr what is its
age and on 8th showing as expired..
what will be the excel based formula for this...