I am trying to create a formula that will take a date in a list, display the
month and day of that list, and calculate the year from a different list to
add 1 year. Returning the date of the first list's month and day, and 1 year
added to the year of the second list.
Sorry, I'm confused too! 8o)
example: Today's date would be 6/19/08
List 1 list 2 Answer I'm
looking for
1/5/01 2/8/07 1/5/08
2/8/05 5/16/07 2/8/08
6/15/04 6/25/08 6/15/09
6/25/04 6/12/05 6/25/06
5/12/06 6/25/07 5/12/08