I am trying calculate a UAT 70 day view that adds 70 days to today's date which represented below by the "
CalcToday" column minus the
UAT START DATE field plus 70 days (mm-dd-yyyy). The formula below returns dates with value that equal ,02-09-1900 and 02-11-1899. Which are definitely. If today is 7/27/2015 and I add 70 days the return should be 11/7/2015. If subtract the
UAT START DATE of 7/17/2015 the value should be 10/27.2015. How can I fixe my formula? Thanks.
=TEXT([CalcToday]-[UAT START DATE]+70,"mm-dd-yyyy")