LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for calculating time period between 2 dates Raj[_5_] Excel Discussion (Misc queries) 3 December 9th 09 05:18 PM
calculate the the diffrence between 2 Dates and time LKWP Excel Worksheet Functions 2 July 2nd 08 02:15 PM
is there a formula for calculating dates 3 mos out Lawrence Excel Discussion (Misc queries) 1 July 28th 06 06:46 PM
Cells with time format and calculating the diffrence MikeR-Oz New Users to Excel 11 January 3rd 06 10:11 AM
Need help with a formula for calculating based on a rage of dates djeans Excel Discussion (Misc queries) 7 July 2nd 05 09:06 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"