formula

Occasional Contributor

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

1 Reply

@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)