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
try this..
Formula:
=INT((A2-A1)/7)+MOD((A2-A1)/7,1)*7/10
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Dear Debraj Roy:
Many thanks, it works. God bless you.
Your prompt action is highly appreciated.
Regards,
Sajj
Thanks for the feedback & Rep..
I dont know, why i am replying this NOW().. but its interesting, so just want to share..Originally Posted by Sajj55
Formula:=DOLLARFR((A2-A1)/7,7)
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 useFormula:=DOLLARFR(A1,3)
and incase of reverse.. to display 10.2 as 10.6666, we can also use.. DOLLARDE
and to display 10.2 as 10.6666 useFormula:=DOLLARDE(B1,3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks