| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula required for Month wise calculation
I have Check in date and check out date in Column B and C and total cost in Column E
Suppose in Date is 1April 2014 and Out date is 1 May 2014, then I need a formula for cost calculation for only month of April 2014. your assistance in this regards will be highly appreciated. Regards, Vikkhen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula required for Month wise calculation
=(C-B)*Rate
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula required for Month wise calculation
If you want to include 1st may also then
=(C-B+1)*Rate |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula required for Month wise calculation
On Thursday, September 14, 2017 at 8:16:17 PM UTC+5:30, TIMOTHY wrote:
If you want to include 1st may also then =(C-B+1)*Rate Dear Timothy, It would be very helpful if you share me your mail id or drop me test mail from your id on so that i will share you the exact issue with you. Regards, Vikkhen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Month wise Sum | Excel Worksheet Functions | |||
| Formula required for # of days Calculation | Excel Discussion (Misc queries) | |||
| How to get month wise total of a worksheet having a years data? | Excel Discussion (Misc queries) | |||
| Date wise Sum Formula required | Excel Discussion (Misc queries) | |||
| Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
Linear Mode
