Week & days in a cell

[Sajj55]

I have a cell containing the back date & the other has a current date, I would like to get the result in next cell with total weeks become between these two dates and also the remaining days in numbers i.e. 1 to 7 days. Result should shows like this 4.6, 4 denotes weeks & 6 denotes days. I have tried the formula =(A2-A1)/7, but it showed number of weeks but after decimal it do not show the number of days. Anyone can help.

Sajj

[Debraj Roy]

try this..

Please Login or Register  to view this content.

[Sajj55]

Dear Debraj Roy:

Many thanks, it works. God bless you.
Your prompt action is highly appreciated.

Regards,

Sajj

[Debraj Roy]

Thanks for the feedback & Rep..

[Debraj Roy]

Result should shows like this 4.6, 4 denotes weeks & 6 denotes days

I dont know, why i am replying this NOW().. but its interesting, so just want to share..

Please Login or Register  to view this content.

By DOLLARFR, function, you can denote FRANCTION part, other that 10.. which means 2/3 (0.6666) can also be denoted as (0.2)
to denote 10.6666 as 10.2 use

Please Login or Register  to view this content.

and incase of reverse.. to display 10.2 as 10.6666, we can also use.. DOLLARDE
and to display 10.2 as 10.6666 use

Please Login or Register  to view this content.