How to calculate dates between two dates

[Molson]

I have a spreadsheet with a series of tasks that have a start date and and end date. Task number 1 has a start date of 06/01/15 and an end date of 05/25/16. I have been able to calculate the number of months between each date using =DATEDIF(startdate,enddate,"m"). The result of this = 11 months. I would like to calculate a date (end of month) for each of the 11 months.

Any help with this would be very appreciated

Thank you

 

[Faseeh]

Hi Molson,

Please post a sample file. It will be helpful for others.

 

[Khalid NGO]

Hi Molson,

I have made a sheet for you as per my understanding.

I am not much familiar with DATEDIF, but see if this is okay.

Regards,

 

[Molson]

Hi Molson,

I have made a sheet for you as per my understanding.

I am not much familiar with DATEDIF, but see if this is okay.

Regards,

Hi Khalid,

This is very helpful. One small request. Would you be able to reference the formula in columns instead of rows in a single column. I tried to change your formula to use =COLUMN() but I got lost in the cell references. I have uploaded your sheet with the change request. I very much appreciate the help

Regards

 

[Khalid NGO]

Hi Khalid,

This is very helpful. One small request. Would you be able to reference the formula in columns instead of rows in a single column. I tried to change your formula to use =COLUMN() but I got lost in the cell references. I have uploaded your sheet with the change request. I very much appreciate the help

Regards

Here it is....

But I have just noticed a problem, 31-July-15 is missing in both version
Don't know why.

 

[Molson]

Here it is....

But I have just noticed a problem, 31-July-15 is missing in both version
Don't know why.

Thank you. I will take a look at the 31 Jul issue.

Best regards

 

[Molson]

Thank you. I will take a look at the 31 Jul issue.

Best regards

Hi Khalid

The formula will always skip the second month. Perhaps it is related to the column reference due to column "C"

I will continue to troubleshoot. If you find the issue please let me know

 

[Khalid NGO]

Hi Khalid

The formula will always skip the second month. Perhaps it is related to the column reference due to column "C"

I will continue to troubleshoot. If you find the issue please let me know

Hi Molson,

I tried this for column version, and its working, please check:

=IF(EOMONTH(EDATE($B2,-1),COLUMN(A1))>EOMONTH($B3,0),"",EOMONTH(EDATE($B2,-1),COLUMN(A1)))

Regards,

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Molson]

Hi Molson,

I tried this for column version, and its working, please check:

=IF(EOMONTH(EDATE($B2,-1),COLUMN(A1))>EOMONTH($B3,0),"",EOMONTH(EDATE($B2,-1),COLUMN(A1)))

Regards,

Khalid

Thank you. This works perfect

Regards