Can someone help me with a function that will automatically count down the days until a tenants rent it due?
Can someone help me with a function that will automatically count down the days until a tenants rent it due?
if you put the due date in cell a1, use =a1-today()
not a professional, just trying to assist.....
Ok, sorry changed my mind....here's what I need to do:
I don't really know the due date...the tenants rent for a certain amount of weeks at a time, and I wanted to count down from say...56 days. So, if a1 was 56, how would I count down from there? Is that possible? Also is it possible to automatically email me when it says 2 days are left? Thanks
Last edited by HeatherDawn; 01-08-2005 at 10:17 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks