Solved: Weeks, Days and Total Days between two dates - Page 2

Skip2MiLu · 09-22-2023 01:29 PM

How do I create an appsheet formula that the same thing as what this excel formula does, where cell F5 is equivalent to [Sowing Date] column & H5 is equivalent to [Planting Date] column

TEXT(INT(DATEDIF(F5,H5,"d")/7),"00")&" weeks & "&TEXT(MOD(DATEDIF(F5,H5,"d"),7),"00")&" days ("&TEXT(DATEDIF(F5,H5,"d"),"00")&" days total)"

Below is an example of how a result would look like
05 weeks & 05 days (40 days total)

Suvrutt_Gurjar

Please try

CONCATENATE(

RIGHT("00"&(FLOOR(HOUR([Planting Date]-[Sowing Date])/168)), 2), " weeks & ",

RIGHT("00"&(MOD(HOUR([Planting Date]-[Sowing Date])/24,7)),2), " days ",

"(", HOUR([Planting Date]-[Sowing Date])/24, " days total)"

)

View solution in original post