Please suggest a formula

Pranjal (Student CA IPC / IPCC) (531 Points)

24 February 2012  

I've to request for funds for any activity from Regional Office at least 21 days prior to the actual date of activity.Please suggest me an excel formula where by when I put the activity date it automatically gives me the date by which I've to request funds.Please remember we have a five day working week & as such Saturdays & Sundays are not taken into account while calculating the said 21 days.