How to sum and get a total based on a specific date?

Is there any way or formula to do this in appsheet?

Please take a look at the sample app below that has records selection based on user input and is principally similar to your requirement. You could further sum those selected records to get a sum.

You could use a SUM() on the filtered records in teh slice.