Oct 08 2022 04:35 AM
Hi I am trying to create a formula to give me a total between toays date and 14 days in future at the moment I am getting Errors
Oct 08 2022 04:44 AM
@MarkBeck54 Without seeing your file, I can only guess. But a formula like below will do just that. "values" refers to the range you want to some from and "dates" refers to the range containing the dates.
=SUMIFS(values,dates,">="&TODAY(),dates,"<="&TODAY()+14)