- Dec 22, 2004
- 15
- 0
- 0
Hello. Im trying to figure out a formula for a range of dates minus the weekends. I want something like: date from previous entry + 12 + 1 to 7 days - weekends.
A1=Date, ie "jan 1, 2005"
A2=Date + 12 + 1 to 7 days - weekends, ie "Jan 13,2005 to Jan 21, 2005"
I dont even know if this can be done with excel, but any help would be appreciated.
Thanks
A1=Date, ie "jan 1, 2005"
A2=Date + 12 + 1 to 7 days - weekends, ie "Jan 13,2005 to Jan 21, 2005"
I dont even know if this can be done with excel, but any help would be appreciated.
Thanks