Can someone help me with IF Function formatting for dates? Specifically I'm looking for a way to use the IF Function to post a date of one year (365 days) past the given cell value, or 9/15/2012, whichever is later.
For example, IF ((A4) + 365) < (TODAY) then return 9/15/12, else return (A4) + 365.
Having trouble formatting it exactly right to get the value I want, though. Thanks!
-Paul
Bookmarks