Thread: Holiday / Attendance Form

Hello

I have added some dates in 'Holiday Dates' sheet for Hayley and Lisa ( green coloured cells). Now see "July 2009" sheet. See formulas in 'Green coloured" cells. Hope this will help u.

Hi

see attached file. I have added 'Sick' sheet and changed formula in 'July' sheet accordingly. Moreover now I have made use of 'Conditional Formatting." So whenever there is 'H', cel will automatically be green and for "S" (Sick) it will be automatically red.
Hope this helps u.

Bye

You are the man. Thank you so much

Last question...I Promise.

I need to add one more sheet 'Other' I am having trouble with the code/formula. I want it to put an 'O' on the month sheet.

Please help

Again thanks for your help

ta

bud

Hello

added 'Other' sheet and formula changed accordingly. See attached file - 'July sheet'

Hi everyone.

Hope you are all well.

I need to be able to add half ways on the Holiday, Sick and Other sheet (on the spreedsheet attached to previous post).

At the moment I add the halfday on the holiday Tab as 1/2 14/11/2011 and then I have to got the date of the month sheet and Type HH (half day holiday). Is there any way I can get this to automaticlly populate as HH?

Thanks


Bud

Any Ideas anyone?

Thanks

bud

Pl see attached file.

Hi Kvinivasamurthy.

I have downloaded the spreadsheet. What am i looking for?

Thanks

bud

Anyone else got any ideas on how I would do this? I am really struggling.

Thanks

nel

Any Ideas on the half day question anyone.

Any help is appreciated

Thanks

bud

Uploaded file not available.Pl upload the file.Let me try.

Hi kvsrinivasamurthy

Not sure what happened to the attachment. Ihave just uploaded another one.


Many Thanks in advance

bud