Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between Dates
cell b2=02/11/2006 cell c2=100 cell d2=200 I want my result to be if b2 is between a certain date range, then add c2 and d2, else 0. How do I perform the date range part of the formula? -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=521172 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between Dates
Try this formuila:
=IF(AND(B2<=DATE(2006,3,1),B2=DATE(2006,2,1)),C2+ D2,0) this will check whether your date is between the range 2/1/06 and 3/1/06 "exsam21" wrote: cell b2=02/11/2006 cell c2=100 cell d2=200 I want my result to be if b2 is between a certain date range, then add c2 and d2, else 0. How do I perform the date range part of the formula? -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=521172 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between Dates
With: Start Date in G1 End Date in H1 E2: =(B2=$G$1)*(B2<=$H$1)*SUM(C2:D2) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=521172 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |