Hello:

I need a formula that adds a new date whenever a specific date comes: Something along the lines of: "If date is <> April 1, then add April 1, if not then do nothing." Another formula on a separate cell in the same row: "If date = April 1, then find rate on separate sheet, if not do nothing".

2009-03-31
2009-04-01 ----> this is the one I'd like to automatically add
2009-05-26

Background: I'm working on a table where I am applying a rate for a service. Every 1st of April, the service rates change. Obviously, if the date is not April 1st, the prevailing rate stands (pre April and post April).

Thanks!!!