Time sheet Semi-monthly

Hi,

I am trying to create a Semimonthly time sheet, but I am facing a problem with the dates. Actually I am new at using Excel and don't have any idea how to automatically make the dates change, I am able to create from 1st to 15th but not from 16th to 31st. If any one have a sample time sheet for a semimonthly please help me out it's urgent.

Thank you
Srikanth

Srikanth,

Can u please elaborate as to what exactly are you looking out for...
Maybe a small example or a Sheet attached..

Hi,

Thank you for your quick reply, I am attaching the file that I am working on. If I enter the date as 11/16/2008 then the last cell is showing 12/1/2008 because november has 30 days only so I want a time sheet which can automatically calculate the days in the particular month and produce the time sheet accordingly. I have tried in many ways but I was suggested to use Macro's and I don't have any idea on this topic. So it would be great if you could suggest me some solution.

Thank you
Sri

hey Sri,

This should work for you...

Cop this formula and put it in the Cell A11

[ IF(ROW()=MATCH("Day of Week",$A:$A,0)+1,$G$8,IF(MONTH($A10+1)<>MONTH($G$8),"",$A10+1)) ]

Hi,

Sorry 2 ask this question can u explain me wht to fill in these fields as per ur post
IF(ROW()=MATCH("Day of Week",$A:$A,0)+1,$G$8,IF(MONTH($A10+1)<>MONTH($G$8),"",$A10+1))

logical_test:
value_if_true:
value_if_false:

but I want u 2 thank for a potential response..

Thank you
Sri

Originally Posted by kalagara27

Hi,

Sorry 2 ask this question can u explain me wht to fill in these fields as per ur post
IF(ROW()=MATCH("Day of Week",$A:$A,0)+1,$G$8,IF(MONTH($A10+1)<>MONTH($G$8),"",$A10+1))

logical_test:
value_if_true:
value_if_false:

but I want u 2 thank for a potential response..

Thank you
Sri

Step-1
IF(ROW()=MATCH("Day of Week",$A:$A,0)+1

Basically, it needs to get the answer 11 which you get using the Match function.. MATCH("Day of Week",$A:$A,0)+1....

What it means if its the 11th Row then simply copy the same valuse as in $g$8 your Staring Date, however for any other rows other than 11, you need to keep on adding 1 i.e. Starting date + 1

So this will start getting executed from Row=12 (i.e A12) as We get the Date as G8 in A11 we just keeping on adding 1 till we come across a First date of the Next month...
=IF(MONTH($A10+1)<>MONTH($G$8),"",$A10+1))

If the month of the Starting Date and the date which we get differes which will occur only when the date turns to 1-Dec-08 so it will check if the months are same, if they are not then it will blank it out by " "...

Hope this helps...

Sir
I looked at you time sheet. I copied the formula that was posted, but it did not work for me. I may be doing something wrong. The formula I used is below. Copy and paste it into A12 and drag it through A26. One other thing since it is semi monthly did you want it to stop on the 15th for the first half of the month. If so we will need to change to the formula. I hope this will help if the previous formula did not help. GOOD LUCK!

=IF(MONTH(A11+1)<>MONTH(A11),"",A11+1)