I have a formula that i am trying to convert date to Text. I can do that fine but i cannot add a week to it. Thanks in advance
In Cell A1
=TEXT(U2,"mmm
dd
yy")
and Trying to in B1 I would like to write a formula that takes this date in Text format and add 1 week
=A1...+1 Week