| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Inbetween dates
Hi
How do I show that a date in a row is inbetween a date. Say: I have a cell called 'Datecell' and I want to count each row with a date in the past 12 months of this date. How would I do this? I originally had =IF(DateCell-365<=E2,"Yes"). Although this counts everything in the past 12 months and gives it a 'Yes', it also counts everything after the date in the 'DateCell' and not inbetween the two dates. Anyone know a solution? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT INBETWEEN A DATE RANGE | Excel Discussion (Misc queries) | |||
| dates inbetween | Excel Discussion (Misc queries) | |||
| Count Dates between Dates exclude Text | Excel Discussion (Misc queries) | |||
| NEED TO SHOW EACH DAY INBETWEEN TWO DATES, help please | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Threaded Mode
