Hello. I copied dates (formatted like 6/30/2021 16:05) from PointClickCare software and pasted them into an Excel file. When I try to substract two of the dates in Excel, I get a "#VALUE!" error.
Example: Cell B2 has 6/30/2021 16:05
Cell B3 has 5/5/2021 16:30
Cell C2 has =B2-B3
Is there a way for me to calculate the number of days between the two dates?
Note: It's okay if the hours and minutes (e.g. 16:05) get removed from the cells. It's also okay if the date format gets changed.
Thank you!
Bookmarks