Forum Discussion
SUMIFS function not working with date range
I am attempting to calculate debits from a ledger within monthly date ranges. However, I am only getting a "0" as a result. As far as I can tell, I am doing everything correctly. I have formatted all...
So using this logic (excuse the pun), I might be able to import the date data, convert it to a numerical date for the formula's purposes, but then have the "displayed" formatting change the appearance of the data back to a date format while still maintaining the usefulness of the data in my formula?
so when I use the Text to Columns it did change it to a Long Date formatting appearance and yes I just went back up to the formatting options and changed it to show as Short Date at which point it looked the same as how it started but now is actual Values instead of Text.