Perhaps change it to..
=IF(H6="","",DATE(YEAR(H6)+1,MONTH(H6),DAY(H6)))
Perhaps change it to..
=IF(H6="","",DATE(YEAR(H6)+1,MONTH(H6),DAY(H6)))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks