-What formula should I use if I wanted to calculate the number of days between the date in column D and the date in column J once a date is filled into column J and place the answer in column K?
I have been trying to figure this out and am going to continue to do so. I figured I'd ask while I continued working on it.
Thank you in advance for any help.
Tara
Last edited by TMack; 02-18-2013 at 01:12 PM. Reason: Typos
Maybe..
=IF(J1="","",D1-J1)
format as number
Life's a spreadsheet, Excel!
Say thanks, Click *
I got this formula to work:
=IF(ISBLANK(D157),"",IF(J157=0,"",J157-D157))
Yours is much simpler. When I had column D before column J it gave me a negative, so I switched those around.
Thank you for your response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks