Date calculation!
In Cell E2 I have a date (generated by another formula ) this is an Installation Date in the format dd/mm/yyyy e.g 21/04/2009
I need a date automatically entered into Cell D2, the Despatch date, which is 3 WORKING DAYS ( MON-FRI ) before the installation date.
A real example might be say the Installation Date is Monday 23rd March 2009 in Cell E2, then the Despatch Date needs to be Wed 18th March 2009 e.g. 3 working days earlier
Thanks Ed
In Cell E2 I have a date (generated by another formula ) this is an Installation Date in the format dd/mm/yyyy e.g 21/04/2009
I need a date automatically entered into Cell D2, the Despatch date, which is 3 WORKING DAYS ( MON-FRI ) before the installation date.
A real example might be say the Installation Date is Monday 23rd March 2009 in Cell E2, then the Despatch Date needs to be Wed 18th March 2009 e.g. 3 working days earlier
Thanks Ed