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)
Thank you for your reply. I greatly appreciate the time you've taken to answer.
Michael1105 , you are welcome