Hello,
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. 
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.
