Analyzing whether a project was on time or late
I need a spreadsheet that will look at specific columns and determine based on the calendar dates entered in those columns whether a project was a) submitted On Time or Late, and b) the # of Days Early/Late it was submitted. Please see the attached spreadsheet as an example. I have highlighted in green what I'd like the spreadsheet to automatically populate.
Thanks!! I really love this forum.
Re: Analyzing whether a project was on time or late
I believe I answered my own question. Here is the formula I used to populate whether a task was On Time or Late with L4 being the column showing the Due Date and M4 being the Submitted Date.
Here is the column for the # of days Early and Late.
=IF(COUNT(L4,M4)=2,TEXT(M4-L4,"0 ""Day(s) Late"";0 "" Day(s) Early"";""0 Day(s) Early"""),"")
Hope this info helps someone else out.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1