Thread
:
=max function on dates
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Dave
external usenet poster
Posts: 1,388
=max function on dates
Hi,
Try something like:
=SUMPRODUCT(--MAX((A2:A100)*(A2:A100<TODAY())))
Change the ref's to suit your data.
Regards - Dave.
Reply With Quote
Dave
View Public Profile
Find all posts by Dave