Date formula Puzzeled

Closed
Report
Posts
2
Registration date
Tuesday September 14, 2010
Status
Member
Last seen
September 14, 2010
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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 .

thanks in advance
Joe.

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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