Time sheet issues

  • Thread starter Thread starter Srinivasulu Bhattaram
  • Start date Start date
S

Srinivasulu Bhattaram

There are three questions
I am preparing a time shhet.
To strart with I have to prepare a blank sheet and give one sheet for each
emlpoyee
Here are the blank walls I am hitting
1. I want to format a cell (E2 in my time sheet) in such a way that if
enter "1" it should display "January" and so on. How to do it?
2. The First cell of last row (A 34 in my of the time sheet) should have 28,
29, 30 or 31 depending the conditions of E2 and H2 which has month and year
respectively.
3. The cells B4 to B34 should have days cooresponding to dates (number) in
A4 to B34
They should be filled with only with "Sunday" and for remaining days it
should be blank.
All these years I have been doing these sheets manuallly.
On one or two occasions there were errors, which I thought could be avoided
if thse are conditionally formatted
Hence this request
seena

I am NOT attaching a sample sheet. I do not know whether attachments are
allowed in this list.
If it any one needs , I can send it off the list.
seena
 
Srinivasulu Bhattaram said:
There are three questions
I am preparing a time shhet.
To strart with I have to prepare a blank sheet and give one sheet for each
emlpoyee
Here are the blank walls I am hitting
1. I want to format a cell (E2 in my time sheet) in such a way that if
enter "1" it should display "January" and so on. How to do it?
Click to expand...


In F2: =TEXT(DATEVALUE("01/"&E2),"mmmm")

2. The First cell of last row (A 34 in my of the time sheet) should have
28, 29, 30 or 31 depending the conditions of E2 and H2 which has month and
year respectively.

=DAY(DATE($H$2,$E$2+1,0))


3. The cells B4 to B34 should have days cooresponding to dates (number) in
A4 to B34
They should be filled with only with "Sunday" and for remaining days it
should be blank.
Click to expand...

A4: =IF(A4="","",IF(WEEKDAY(DATE($H$2,$E$2,A4))=1,"Sunday",""))

copy down
 
Thanks!
How nice of you!
You have replied so fast
I will use them and get back to you if there are any issues
Thanking you once ....I remain.
 
Back
Top