In column D I have data in the format year / month / day. My goal is to get information in column H about the total number of days in relation to column D.
First I transferred the data from column D to columns E: G and tried to collect it in the end. It seems that the data from the E: G column is in the form of a text and not a number, and therefore it cannot perform the calculation for me.
Idea how to calculate this?
Please Login or Register to view this content.
Last edited by ahmo73; 01-30-2021 at 08:03 AM. Reason: Wrong column X instead H
Try changing this:to this:Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Again the same: "#VALUE!"
there are invalid punctuation marks in the 'date'
Try this
Please Login or Register to view this content.
Where do you get your data from? It's bracketed by non-printable character 63.
Please Login or Register to view this content.
Perfect, thank you.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks