Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date related Problem
Hi all,
Can any body solve my problem like i have to add some cells value (COL E )which are comes under a particular month and which are corresponding and inbetween of those two dates like fist date of the month and last date of the month.( eg. comes under COL C and COL D). take the example of March month the value of Coleumn E should give the addition of all the cell value which will come or corresponding to COL C and COL D of dates 01/13/08 and 31/13/08. ColA COL B COL C COL D COL E ID Task Name Actual Start Actual Finish BCWS 1 Receipt of PO 03/13/08 03/14/08 $640.00 2 Receipt of advance 03/14/08 03/18/08 $1,230.00 3 Assigning Project Id 03/20/08 03/20/08 $200.00 4 Preparation - SDP 03/21/08 03/25/08 $960.00 5 Review - SDP 03/24/08 03/25/08 $170.00 6 Project Initiation 03/29/08 04/03/08 $493.00 7 Rework - SDP 04/15/08 04/16/08 $560.00 8 Project startup audit 04/18/08 04/18/08 $80.00 9 Maintain SDP 04/19/08 04/21/08 $200.00 Any help will be appriciated from your side. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro problem related with all worksheets | Excel Worksheet Functions | |||
Solver Problem ( related to earlier post of using if an Vlookup) | Excel Worksheet Functions | |||
problem of copying column related to date | Excel Discussion (Misc queries) | |||
Non-excel related problem about thumbnails | Excel Discussion (Misc queries) | |||
New Router, Excel problem.. are they related! | Excel Discussion (Misc queries) |