# Date formula Puzzeled

Closed
mariejose2636 Posts 2 Registration date Tuesday September 14, 2010 Status Member Last seen September 14, 2010 - Sep 14, 2010 at 12:30 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 16, 2010 at 10:01 AM
Hello,

Hi , can any one help me in this ,
that i have used this formula

And if you want to know a date with adding a number of months to an other date :
A B C
1 Start month No. of months End months
2 1/5/2009 4 ?

Tried with this formula in C2 :

=MIN(DATE(YEAR(A2),YEAR(A2)+C2+1,0),DATE(YEAR(A2 ),MONTH(A2)+C2,DAY(A2)))

But i can't able to find the end date.
CAN ANY ONE HELP ME IN THIS .

Joe.

## 1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 16, 2010 at 10:01 AM
Hi Joe,

I don't see the logic of your formula, but it does work if you replace the C2's by B2's. But why not use just the last part like:

=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))

Best regards,
Trowa