Kenshinpls

 Messages 316 #1 Hello all, I want the following formula to return this As of Here's what I have ="As of "&today () I get the date in text format (ie ) So here I have a list of dates ranging from 12/1/19 to I want to be able to sum the values that are from 50 to 100 For that I will use the SUMIFS function The syntax for the SUMIFS function is =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2,) So the formula we'll use is Current date formula =TODAY() Current time formula =NOW() Excel current date and time example Let's look at a real example in an Excel spreadsheet of how these two formulas work In the screenshot below, you can clearly see how Add Or Subtract Dates Excel Excel today's date plus weeks