Forum Discussion
Simple property management system
I am developing a simple property management system that would calculate the remaining rent days from the last date of payment. i have design date column from K5:AT5 with headers as 31/03/2024, 30,0...
In row 6:
=XLOOKUP(1000000000, $K6:$AT6, $K$5:$AT$5, "", -1, -1)-TODAY()
Format the cell with the formula as General, then fill down.
Thanks Hans,
that formula fail to work with me, it only bring #Values.. so i used this "=TODAY()-INDEX(K:AV,5,(COUNT(L6:AV6)+1))" and it worked.
that formula fail to work with me, it only bring #Values.. so i used this "=TODAY()-INDEX(K:AV,5,(COUNT(L6:AV6)+1))" and it worked.