I have a spreadsheet I am working on and cant get the date formula right. I have looked everywhere but cant find the answer to my problem. I know it is probably simple but cant seen to come up with it. Example of problem. My first date I want to plug in is say May 15, 2013. I need to formulate 3 other cells so the dates appear as 1 year less from original date and 3 months later than original date and the day stays the same, next cell 1 year less and 6 months later day stays the same, next cell 1 year less 9 months later and day stays the same. Someone please help me. I have a big project coming up and I need to impress the boss with this spreadsheet.
Bookmarks