Hello!
I'm trying to have this formula round + add a "w" to the end but I cannot seem to figure it out.
The formula is:
=(Due1 - Due@row) / 7 + "w"
I would like it to say 12.9w but it keeps saying 12.85714w and I've tried using the "Decrease Decimal" option and it does not work.
Due1 = 2/24/20
Due@row = 11/26/19
90-day variance that I'm trying to calculate out in weeks rounded to the nearest tenth decimal.