Formula for calculating the diffrence between two dates

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number of months and days between two dates without approximation 3
Formula for calculating time period between 2 dates 3
Calculating total elapsed minutes between two dates 1
Calculate working hours between two dates 2
What is the formula for calculating the age (Expiry Date) 2
Formula for finding Date difference between 2 dates 4
Adjusting a formula to collect data between two dates? 8
Highest value between two dates 3

Top