I am trying to create a formula where I can total up certain fields each day. Does anyone know of the formula that would allow the use of today's date in a countifs situation?
Hi Dawn I think I've got it, depends on your use case. I quickly mocked up a sheet to show me my orders, when they were entered and when the sale date is, with order 3 happening in the future. So my actual sales is calculated at the top
Thank you so much!! This was a big help. I was able to do =sumif(date:date, Today(), Value:Value) so this way it totals everything for todays date.
