WORKDAY function

[mcarter973]

I am using the workday function (w/ brackets for holidays). I also want to use the month end date even if it falls on the weekend or holiday. For instance, the last business day for June is the 28th (Friday) and June 30 is a Sunday. For my spreadsheet I want to show June 30.

Can this be done?

Thanks

 

[kinkyparamour]

Try this link, you should find everything you ever wanted to know about working with dates here...............

http://www.cpearson.com/excel.htm

Denny

 

[Aladin Akyurek]

On 2002-04-15 08:08, mcarter973 wrote:
I am using the workday function (w/ brackets for holidays). I also want to use the month end date even if it falls on the weekend or holiday. For instance, the last business day for June is the 28th (Friday) and June 30 is a Sunday. For my spreadsheet I want to show June 30.

Can this be done?

Thanks

Would this work?

=IF(EOMONTH(A1,0)=WORKDAY(A1,E1,Holidays)-1,EOMONTH(A1,0),WORKDAY(A1,E1,Holidays))

where E1 houses the desired number of workdays and Holidays is the name of the range that houses the holiday days.