If B2 has a date lets say 3/15/09. How can I get D2 to show exactly 3 month ahead to 6/15/09.
R Richard Jun 3, 2009 #1 If B2 has a date lets say 3/15/09. How can I get D2 to show exactly 3 month ahead to 6/15/09.
S smartin Jun 3, 2009 #2 Richard said: If B2 has a date lets say 3/15/09. How can I get D2 to show exactly 3 month ahead to 6/15/09. Click to expand... Define "exactly 3 months ahead from 3/31/09". Or better: "from 11/30/09" You could try =DATE(YEAR(B2),3+MONTH(B2),DAY(B2)) But it may not be what you want.
Richard said: If B2 has a date lets say 3/15/09. How can I get D2 to show exactly 3 month ahead to 6/15/09. Click to expand... Define "exactly 3 months ahead from 3/31/09". Or better: "from 11/30/09" You could try =DATE(YEAR(B2),3+MONTH(B2),DAY(B2)) But it may not be what you want.
R Richard Jun 4, 2009 #3 Thanks so much! Thats perfect smartin said: Define "exactly 3 months ahead from 3/31/09". Or better: "from 11/30/09" You could try =DATE(YEAR(B2),3+MONTH(B2),DAY(B2)) But it may not be what you want. Click to expand...
Thanks so much! Thats perfect smartin said: Define "exactly 3 months ahead from 3/31/09". Or better: "from 11/30/09" You could try =DATE(YEAR(B2),3+MONTH(B2),DAY(B2)) But it may not be what you want. Click to expand...