Formulas rto split start and end dates into 24 even dates

[tonywatsonhelp]

Hi Everyone,

I'm trying to create a chart that show a timeline and need to divide a start and end date up into 24 even dates

The Start date is in Cell L11 End date in M14

Can this be done?
what happens if the two dates are less than 24 days apart?

please help thanks

Tony

 

[Peter_SSs]

what happens if the two dates are less than 24 days apart?

What happens if the dates are more than 24 days apart but not an even multiple of 24?