LinkBack URL
About LinkBacks
This should do the trick
=IF(O7>$E$3,"Not Started",IF(DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d")<1,DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d"),"Complete"))
This should do the trick
=IF(O7>$E$3,"Not Started",IF(DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d")<1,DATEDIF(O7,$E$3,"d")/DATEDIF(O7,Q7,"d"),"Complete"))
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks