Martin has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Date Calculator
How can I use Excel to create a spreadsheet calculator where, if I enter a series of given dates in one column, Excel will enter a date 6 working days prior to the given date, exluding Saturdays, Sundays, UK Bank and Public Holidays + another other dates I wish excluded? THe outcome I'm looking for is 6 working days prior to the given date.
Thanks
Martin
RE: Date Calculator
Hi Martin, thanks for your query. You need Excel's WORKDAY function. Rather than me duplicate the walkthrough, have a look at this, I think it's pretty much what you're after:
http://office.microsoft.com/en-us/excel-help/workday-HP005209339.aspx
Hope this helps,
Anthony
RE: Date Calculator
Hi Anthony,
Many thanks for the information which does help.
However, I must apologise because having tried the suggestion out, I now realise that as part of my original post, I should have indicated that some of the dates which I need the formula to calculate will be in the past.
Eg the given date could be 01/08/10. Can I use WORKDAY (with some dates to be excluded from the calculation) to return a date however many workings days necessary BEFORE the given date.
Many thanks in advance and apologies for the lack of complete infromation in the first place.
Regards
Martin
RE: Date Calculator
Hi Martin, that shouldn't be a problem. Just make the "days" argument of the function negative to work backwards.
Hope this helps,
Anthony
