Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default duration days

hi all
i want to ask about this calculation:
if i have a date for sell and the date for billing and i want to caculate
the diffrence between them with a quirey if the days more than 10 days the
result no discount and if it is less than 10 days it eill be extra discount
like 3% and if the days more than 20 days that means tax 10% can any body
help me?
 
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
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz naughtyboy Excel Discussion (Misc queries) 3 August 19th 06 05:45 PM
Please Help With Days Elapsed And Days Remaining Calculation Scoooter Excel Worksheet Functions 2 June 14th 06 05:10 PM
No. of days split into periods Brian Ferris Excel Discussion (Misc queries) 3 January 31st 06 03:29 PM
Calendar Days and Option Buttons Andy Excel Discussion (Misc queries) 0 January 10th 06 09:50 PM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM


All times are GMT +1. The time now is 06:01 AM.

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"