Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for calculating time period between 2 dates | Excel Discussion (Misc queries) | |||
calculate the the diffrence between 2 Dates and time | Excel Worksheet Functions | |||
is there a formula for calculating dates 3 mos out | Excel Discussion (Misc queries) | |||
Cells with time format and calculating the diffrence | New Users to Excel | |||
Need help with a formula for calculating based on a rage of dates | Excel Discussion (Misc queries) |