LinkBack URL
About LinkBacks
Try this formula in M4 copied down
=IF(TODAY()>=E4,E4,IFERROR(WORKDAY(TODAY(),-1,IF({1,0},Calendar!A$3:A$100,INDEX(Data!A$3:AN$100,0,MATCH(B4,Data!A$2:AN$2,0)))),TODAY()))
Try this formula in M4 copied down
=IF(TODAY()>=E4,E4,IFERROR(WORKDAY(TODAY(),-1,IF({1,0},Calendar!A$3:A$100,INDEX(Data!A$3:AN$100,0,MATCH(B4,Data!A$2:AN$2,0)))),TODAY()))
Last edited by daddylonglegs; 08-19-2012 at 01:29 PM.
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks