Changing Lookup Value ( Date ) from Strng to Date Value


I use lookup formula to obtain a date value as shown below.

As i could not use it for formula calculation, I create a new column and use formula to point to lookup value. and resulting in a normal date , but it is in string value.

May i know if there is any formula to change this to a normal date value instead of string?

The looked up value is a date and can be used as such in a formula. No need to convert it.

I just tested it with datedif and dateadd.

Maybe my formula is wrong somewhere… i will check again… thanks for your help. :grinning:

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.