ExcelBanter - how can i convert a given # of days to Weeks, and days

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can i convert a given # of days to Weeks, and days (https://www.excelbanter.com/excel-discussion-misc-queries/249023-how-can-i-convert-given-days-weeks-days.html)

Eric

how can i convert a given # of days to Weeks, and days

Rick Rothstein

how can i convert a given # of days to Weeks, and days

Something like this maybe...

=INT(A1/7)&" weeks and "&(A1-7*INT(A1/7))&" days"

An alternate way to write this would be...

=INT(A1/7)&" weeks and "&7*MOD(A1/7,1)&" days"

--
Rick (MVP - Excel)

"eric" wrote in message
...

All times are GMT +1. The time now is 01:10 AM.