$$Excel-Macros$$ Friday to Thursday tracker formula required.

2015-06-07 Thread Avinash
Hi All, I required formula which can give me Friday to Thursday total sum, if today is Sunday then the formula should count last Friday to Thursday total sum. if today is Wednesday then it should do the same last Friday to Thursday . it should not calculate current weeks sum. please see the

Re: $$Excel-Macros$$ Friday to Thursday tracker formula required.

2015-06-07 Thread Nasir Shaikh
Try int.networkdays formula available in 2010 and later On Jun 7, 2015 4:27 PM, "Avinash" wrote: > Hi All, > > > I required formula which can give me Friday to Thursday total sum, if > today is Sunday then the formula should count last Friday to Thursday total > sum. if today is Wednesday then it