I have a calculation to work out number of elapsed days
=SUM(INT((WEEKDAY(A4-{2,3,4,5,6})+C4-A4)/7))-1
But it will return a minus figure until the second date box is filled, which only occurs at the end of a job. Is there a way to make this formula display a blank cell if the figure is a minus?
Monday's.......I hate 'em!
Bookmarks