Date formula in Excel i.e. =date(year(b2),month(b2)+6,day(b2)-1) not giving required result for follwing calculations at Serial 3 & 4.
Name Date1 Date2
Rahat 11/06/2009 10/12/2009
Tauqir 16/06/2009 15/12/2009
Safdar 06/07/2009 #NUM!
Neelo 27/07/2009 #NUM!
would you pls me help on this.
Bookmarks