Finding duration between today and the last date entered
Hello,
I have a row of dates and I need to find out how long it has been opened from the start date. There are 6 columns that have dates and the last column is completed. I need to count the days between the start date and today until the Completed cell is populated. That will give me the total duration of the task from start to finish
You give very little actual detail on what you are working with, so see if you can work this into what you have.
A1=Start date
B1:F1=other dates
G1=TODAY()
=IF(G1="",G1-MAX(A1:E1),"Completed")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Re: Finding duration between today and the last date entered
I apologize for not being clearer.
I will attach my file so you can see the layout. If the Completed cell doesn't have a date in it, I would like to subtract the Assigned date from Today to give me the current duration. Once the Completed cell is filled with a date, the duration counter stops and it stays the same duration since Completed has a date in it.
Does that make sense?
Thank You,
RJL3313
See if this is what you want...
=IF(J4="",TODAY()-B4,J4-B4)
use:
Formula:
Please Login or Register to view this content.
and copy down
Last edited by Kaper; 02-04-2015 at 02:38 PM. Reason: whoops. the net is a qiute slow and erratic today. nevertheless, you got second ,slightly different option.
Best Regards,
Kaper
This works perfectly!!! Thank You so much!!!! Huge help.
Thank You very much
RJL3313
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks