View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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