Formula for calculating the diffrence between two dates

  • Thread starter Thread starter Sanjeev
  • Start date Start date
S

Sanjeev

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...
 
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
 
Back
Top