Date Calculation

[SURESH G]

Dear All,

Please help me to calculate difference between two dates.

Ex:
Start date End date 2011 2012
25/01/2011 30/02/2012 XXXX XXXX

1. Start date is 25/10/2011 and end date is 30/02/2012 in the 2011 column i need formula ( from start date to end of that year duration of months need to calculate)
Answer: 11 months

2. In 2012 Column it should calculate from 01st jan of the 2012 and end date is 30/02/2012. i need formula ( from start date to end date duration of months need to calculate)
Answer : 2 months
Note: if end date is before 31/12/2011 2012 column should be “00”.

[royUK]

Post a Sample WORKBOOK.
Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[SURESH G]

Please find the attachment

[arlu1201]

Read through this article. You should be able to adapt it to your needs -

http://office.microsoft.com/en-us/ex..._months_betwee

[arlu1201]

Your attachment doesnt reflect anything regarding the post. Please check and upload again.

[SURESH G]

Sorry mistakenly i uploaded another one. now i uploaded correct one. Please find

[arlu1201]

Check post 4. If you still face issues, then revert with what issues you are facing.

[SURESH G]

I have uploaded the excel with exatly what i require. expecting answers also given in column C, D, E and F. Please provide formula in the C, D, E and F columns.

[arlu1201]

Did you try the formulae in the link i gave you? What issues are you facing?

[daddylonglegs]

Not sure about how you are counting partial months - this approach roughly rounds to the nearest month

Change the value in C1:E1 to show year number only like 2010, 2011 and 2012 then try this formula in C2 copied across to E2 and down

=IFERROR(DATEDIF(MAX(DATE(C$1,1,0),$A2-15),MIN(DATE(C$1+1,1,1),$B2),"m"),0)

[SURESH G]

Really i can't able to utilize your which you send the link.

If you don't mind can you write formular in C, D, E and F column and give me pls.

[daddylonglegs]

I revised my suggested formula slightly to take into account the rows where you have blanks, this is the new version

=IFERROR(DATEDIF(MAX(DATE(C$1,1,0),$A2-15),MIN(DATE(C$1+1,1,1),$B2),"m"),0)

see attached

[SURESH G]

Thank your very much Daddylonglegs. Almost it is matching, my criteria is if the month is more than 15 days should be count as 1 month. Please do the needful.

[royUK]

have you considered having a go yourself at adapting the formula