Improve FINDITEM() when used with Time

Improve FINDITEM() when used with Time

Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20.

Reason for asking (lifted from my previous post in the Idea Link):

The standard excel format for Month-Year is MMM-YY.

I.e. if a user types Jan 20, excel will convert this to a numeric value and display Jan-20.

1 Comment
Community Manager
 
Status changed to: Your support is needed
Users Online
Currently online: 325 members 1,414 guests
Please welcome our newest community members: