Hi,
I have a list of start date with end date, And now I want to know how many of them ended on exactly on a week calculation like 7 days, 14 days, 21 days, 28 days likewise.
And also I want to know how many of them have not ended weekly basis.
If its ended on weekly basis, in next column, it should appear as Weeks, otherwise Days
Eg : 01-Jan-2016 28-Jan-2016 Weeks
01-Jan-2016 10-Jan-2016 Days
Is this what you meant?
=IF(MOD(B1-A1,7)=0,b(B1-A1)/7&" weeks",B1-A1&" days")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks