On Mar 24, 6:50*pm, Bernd P wrote:
Hello,

How accurate do you need this to be?

Rick's VBA solution and worksheet function solution are fine (the VBA
returns 15-Jul-2004 for 2004, though) if you do not need to care about
bank holidays.

But what will happen on Independence Day 2013, 2024 and 2047? Are you
paying on Friday 5-Jul then?

Wouldn't you need a holiday calendar likehttp://www.sulprobil.com/html/holiday_table.html
for your payments anyway?

Regards,
Bernd

How accurate do you need this to be?

Hi Bernd, not that accurate.... I'm just trying to do a salary
forecast for now....... but that link does look interesting..... I'll
see if I can adopt it for AUS holidays as that may come in handy when
trying to work out penalty rates for working weekends.