Help with a formula

[breezy]

This is a excel question, I posted in the wrong area.. sorry..

I need something simple to figure out set number of working days from the time an employee is hire for evaluations.

new employees that are hired work 4-day weeks

I need something to let me know when they hit the 30-working day date and something that will let me know when they hit the 45 day mark.

So say the start date is November 22, 2009, I would like to know when they hit the 30 working day mark and the 45 working day mark..

TIA..

-k

 

[texasalynn]

I would setup a conditional format with one for the 30 day mark and another for the 45 day mark

Excel Workbook
	A
19	Hire Date
20	10/24/2009
21	11/8/2009
Master

first one conditional format
=TODAY()>=A19+45
second conditional format
=AND(TODAY()>=A19+30,TODAY()<=A19+44)