Forum Discussion
Solved
Difference between two same calculations
Hello, I'm a bit confused why Excel is giving me a total for two calculations that are exactly the same. I have one calculation based on the "DatedIf" argument of 22 weeks between two dates as the...
You can try ROUNDUP. DATEDIF returns 152 days which are 21,714... weeks. ROUNDUP returns weeks without decimals.
=ROUNDUP(DATEDIF(B9,B10,"d")/7,0)
If you count weeks from the beginning of Start one to the end of last one, number of weeks could be calculated as
=WEEKNUM(B10,21)-WEEKNUM(B9,21) +1Second parameter depends on calendar you use.
Thank you for your reply. I greatly appreciate the time you've taken to answer.
Michael1105 , you are welcome