Hyperlinks in date cells prohibiting date's usage in formulas

System

This discussion was created from comments split from: Hyperlinks in date cells prohibiting date's usage in formulas.

jmyzk_cloudsmart_jp

Hi @benzion123_

As @TVang explained, you need to treat the issue date column cell value as text.

https://app.smartsheet.com/b/publish?EQBCT=9288975ad8df4513ab74786242405250

=NETDAYS(DATE(2000 + VALUE(RIGHT([Issue Date]@row, 2)), VALUE(LEFT([Issue Date]@row, 2)), VALUE(MID([Issue Date]@row, 4, 2))), [Expiration Date]@row)

benzion123_

@TVang Would you be able to help me with the correct formula, to get the results even thought that the "Issue date" column has hyperlinks?:

=NETDAYS([Issue Date(Formula)]@row, [Expiration date]@row)

jmyzk_cloudsmart_jp

Hi @benzion123_

As @TVang explained, you need to treat the issue date column cell value as text.

https://app.smartsheet.com/b/publish?EQBCT=9288975ad8df4513ab74786242405250

=NETDAYS(DATE(2000 + VALUE(RIGHT([Issue Date]@row, 2)), VALUE(LEFT([Issue Date]@row, 2)), VALUE(MID([Issue Date]@row, 4, 2))), [Expiration Date]@row)

benzion123_

Wow! It worked!! Tnx a lot @jmyzk_cloudsmart_jp!

jmyzk_cloudsmart_jp

Happy to help!😁