Excel doesn't recognize date printed by Now() Function

[learningthings]

I am printing a timestamp from a userform such that when someone clicks a button, I call the Now() function.
This prints for example, 11/15/2021 9:34:30 AM
But say I want excel to sumif between two dates, it won't recognize the above format as a date

 

[jasonb75]

It should work correctly but what you have told us could be open to a lot of misinterpretation.

Is the date being 'printed' to a worksheet cell? If so, how is that cell formatted? Or if not a cell, then where?
How are you subsequently accessing that date to use with sumif?

 

[learningthings]

Hi Jason, sorry for not providing that info, hopefully this can help:

The date is being printed to a worksheet cell which is formatted as a date.
I am then, in a different worksheet, using the SUMIF formula to only sum quantities between two dates.

 

[jasonb75]

Best guess is that the formula is not written correctly,

using the SUMIF formula to only sum quantities between two dates.

For summing between 2 dates you will need sumifs, not sumif. Where are the 2 dates coming from? You have only mentioned one in your post.
The basic syntax of the formula would be something like this, which allows for any of the date cells containing times as well.

=SUMIFS(quanties,datelist,">="&INT(startdate),datelist,"<"&INT(enddate)+1)