help with date formula
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. |
help with date formula
Richard wrote:
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. 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. |
help with date formula
Thanks so much! Thats perfect "smartin" wrote: Richard wrote: 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. 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. |
All times are GMT +1. The time now is 01:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com