Formula to exclude expired dates

KayH

I'd like to count how many "current" contracts we have

My reference sheet has a column for estimated end date, I just can't find the right formula to exclude dates that fall prior to todays date

Thanks!

Paul Newcome

Are you able to provide a screenshot or some sample data for reference?

KayH

Hi Paul,

I think I worked this one out.. But thanks for your reply anyway!

=COUNTIF({Clinical Trials : Accepted Range 1}, >=TODAY())