Workday

[Papi]

I have a little bit of a dilemma with a formula. I use the formula to shutdown the days at month end based on eomonth. I have been asked to do something similar but only using weekdays so tried using the workday function as noted. Unfortunately, the way it is written it will move to the next month if a month end falls on a weekend. Any help would greatly be appreciated.

Time Sheet Mike (1).xls
	A	B	C	D
23	ThuApr28,11	6:00	8:00	2.00
24	FriApr29,11	6:00	8:00	2.00
25	MonMay2,11	6:00	8:00	2.00
26
April

 

[Joe4]

I am not quite sure I completely follow the logic.

Can you prvoide a few simple examples of your "input" dates, and what dates should result from your formula based on those "input" dates?

 

[Papi]

Thanks Joe 4,

If the worksheet did not try to exlude weekends it would bascially stop the formula from shifting the day into the next month by looking at the cell immediately above. What is happening is when a day like April 29, 2011 shows up on the Friday, the weekend sees May 1 on the Sunday so it posts Monday as May 2, 2011 as it believes the formala to be in the same eomonth, but all I want in each worksheet is for the formula to shutoff at the end of each month rather than starting a new month. Does this make sense?

 

[Joe4]

USe the MONTH function to compare the MONTH of the newly calculated date to the original one, and if the MONTH is different, return a blank (otherwise return the calculation).

 

[Papi]

Thank you Joe4. Sometimes we trip over the simple basics believing there is a more complicated solution to many issues. Many thanks!

 

[Joe4]

Sometimes we trip over the simple basics believing there is a more complicated solution to many issues. Many thanks!

It happens to the best of us!
Sometimes we get in so deep that we can't see the forest for the trees...