May 24 2022 09:26 AM
I have the formula below in a Sharepoint column to calculate the amount of time that has passed since a file was created. The formula is not returning the proper number of days - calculating one more day than it should.
=IF(OR(ISBLANK(Created),ISBLANK(TodaysDate2)),"",IF(AND((WEEKDAY(TodaysDate2,2))<(WEEKDAY(Created,2)),((WEEKDAY(Created,2))-(WEEKDAY(TodaysDate2,2)))>1),(((DATEDIF(Created,TodaysDate2,"D")))-(FLOOR((DATEDIF(Created,TodaysDate2,"D"))/7,1)*2)-2),(((DATEDIF(Created,TodaysDate2,"D")))-(FLOOR((DATEDIF(Created,TodaysDate2,"D"))/7,1)*2)))&" days, "&TEXT(MOD(TodaysDate2-Created,1),"hh "" hrs, "" mm "" mins"""))
May 24 2022 07:29 PM
@Kaptain_1959 I thought I had it once I set the date/time to show hours... and fixed my time zone so it was the same in the site as my profile... but nope, I'm exactly a day off. I'll play around with it some more.
May 25 2022 05:18 AM