Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cells with a value between two dates
I need to calculate the number of products despatched between 2 dates. The date range is in cells A1 and B1 and the date of despatch in cells C1 to C100. I need a calculation, for ecample that will return a count of these items in, say, cell D1. Can anyone help? Thanks -- sumo ------------------------------------------------------------------------ sumo's Profile: http://www.excelforum.com/member.php...o&userid=25338 View this thread: http://www.excelforum.com/showthread...hreadid=388167 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlighting cells which have dates later than... | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) |