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.
Current formula: =TEXT([CalcToday]-[UAT START DATE]+70,"mm-dd-yyyy")