Posted by Tim on January 13, 2000 6:41 PM
I am trying to set up a spreadsheet that will change a date based on wether or not a specific task has been completed by adding 6 months to the date. All originating from an original date.
i.e. A1 = 1/15/00 B1 = 7/15/00 C1 = "y" or "n"
I want to increment B1 to 01/15/01 if "y" or keep it the same if "n" I can do it with number of days
i.e. 180 with =if(c1="y", a1+180, a1+365)
but that does not give me the same day (15th).
is there another way to do this?