Previous Topic Next Topic

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 .

thanks in advance
Joe.

1 response

Answer 1 / 1
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response