Hi I want a Formula to calc the number of:
YEARS, MONTHS, WEEKS and DAYS between two dates
I have tried the following:
DATEDIF (Does NOT calculate the number of WEEKS)
=DATEDIF(A1,A2,"y") & " Years, " & DATEDIF(A1,A2,"ym") & " Months, " & DATEDIF(A1,A2,"md") & " Days"
I realise there are formulas', that JUST calculate the number of WEEKS, such as:
=SUM(B151-B150)/7
OR
=INT((B151-B150)/7)
HENCE TO REITERATE 'A' FORMULA to calculate the number of:
YEARS, MONTHS, WEEKS and DAYS between two dates, would be great.
OR even better 'A' FORMULA to calc the number of:
YEARS, MONTHS, WEEKS, DAYS, HOURS, MINUTES and SECONDS between two dates and times (FORMAT CELLS, custom, dd/mm/yyyy hh:mm:ss) would be great.
Cheers
Stephan Rands<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
07772000679<o></o>
<o> </o>
mail@srands.co.uk<o></o>
<o> </o>
www.srands.co.uk<o></o>
YEARS, MONTHS, WEEKS and DAYS between two dates
I have tried the following:
DATEDIF (Does NOT calculate the number of WEEKS)
=DATEDIF(A1,A2,"y") & " Years, " & DATEDIF(A1,A2,"ym") & " Months, " & DATEDIF(A1,A2,"md") & " Days"
I realise there are formulas', that JUST calculate the number of WEEKS, such as:
=SUM(B151-B150)/7
OR
=INT((B151-B150)/7)
HENCE TO REITERATE 'A' FORMULA to calculate the number of:
YEARS, MONTHS, WEEKS and DAYS between two dates, would be great.
OR even better 'A' FORMULA to calc the number of:
YEARS, MONTHS, WEEKS, DAYS, HOURS, MINUTES and SECONDS between two dates and times (FORMAT CELLS, custom, dd/mm/yyyy hh:mm:ss) would be great.
Cheers
Stephan Rands<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
07772000679<o></o>
<o> </o>
mail@srands.co.uk<o></o>
<o> </o>
www.srands.co.uk<o></o>