Convert date formula to text?... (1 month and 11 days.. etc)

Good morning rayted

I would suggest you use the little known and undocumented Excel function "DateDif".
Chip Pearson provides a good introduction to the feature here.

HTH

DominicB

Hi rayted

Originally Posted by rayted

1) Can I exclude weekdays? (this might be a seperate question!) - all i will require is months and days, not years

Exclude weekdays, or only include weekdays? Either way, I would suggest you use NetworkDays to accomplish this. From the same website, this page documents how to use NetworkDays to calculate differences between two dates.

Originally Posted by rayted

2) As I don't have an end date, I simply need my outstanding date i.e it has been 32 days since the start date, converted into text)

Not quite sure what you're asking here - in your uploaded file you are using the =TODAY() function to grab today's date - isn't that just what you'd use as your end date?

HTH

DominicB

This formula will give you difference in month and days

Formula:

Please Login or Register  to view this content.

If you want to exclude week(end)days from the duration than you should not convert that into months as that will be confusing
as only days and weeks have workdays or workweek counterparts to indicate it will take 1 workweek or 3 workdays