LinkBack URL
About LinkBacks
I have used =int() here, but it only works for some of my dates,
Q
I have used =int() here, but it only works for some of my dates,
Q
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
Your Date & Time Formatted as text so INT function don't work, maybe you need to change your date&time from
8/31/18 14:38:07 to 31/8/2018 14:38:07
Because the dates are M/DD/YY format and you're in Australia and your system is probably configured D/MM/YY you need a more complicated formula. Try this:
Formula:
Please Login or Register to view this content.
If some of your dates are showing as values try this:
Formula:Please Login or Register to view this content.
Last edited by gak67; 09-03-2018 at 12:23 AM.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Please Login or Register to view this content.
Ben Van Johnson
This will treat 9/03/18 as 9 March 2018 in Australia, not 3 September, which is what is intended.Originally Posted by protonLeah
Please Login or Register to view this content.
Try the following in B2:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks