Giving days
 

I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.

I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK

Giving days
 

you may need the Toolpak add in... Tools, Add Ins... Toolpak (don't need the
VBA one..)

use EDATE.

=EDATE(start date,4) will give the date 4 months from your start date. You
should be able to get the rest from there! :-)

"Kay" wrote:

I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.

I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK

Giving days
 

With the first date in A1, In A2 enter:

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1)) and copy down.

Note the date in A1 cannot be too late in the year.

--
Gary''s Student - gsnu200854


"Kay" wrote:

I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.

I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK

Giving days
 

I need to actually enter the number 1 in the cell
--
KK


"Gary''s Student" wrote:

With the first date in A1, In A2 enter:

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1)) and copy down.

Note the date in A1 cannot be too late in the year.

--
Gary''s Student - gsnu200854


"Kay" wrote:

I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.

I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK

Giving days
 

So.. your spreadsheet has a list of dates, and you want to put "1" in the
cell corresponding to the day 4 months (then 8, 12, etc) later?

"Kay" wrote:

I need to actually enter the number 1 in the cell
--
KK


"Gary''s Student" wrote:

With the first date in A1, In A2 enter:

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1)) and copy down.

Note the date in A1 cannot be too late in the year.

--
Gary''s Student - gsnu200854


"Kay" wrote:

I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.

I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK

Giving days
 

The dates are for different persons and I want to give them 1 every four
months; I have the cell D8:O8 with the month starting JUly and ends with JUne.
--
KK


"Sean Timmons" wrote:

So.. your spreadsheet has a list of dates, and you want to put "1" in the
cell corresponding to the day 4 months (then 8, 12, etc) later?

"Kay" wrote:

I need to actually enter the number 1 in the cell
--
KK


"Gary''s Student" wrote:

With the first date in A1, In A2 enter:

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1)) and copy down.

Note the date in A1 cannot be too late in the year.

--
Gary''s Student - gsnu200854


"Kay" wrote:

I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.

I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK

Giving days
 

Assuming your start date is in cell A1:

=IF(OR(MONTH($A1)=MONTH(EDATE(B8,0)),MONTH($A1)=MO NTH(EDATE(B8,4)),MONTH($A1)=MONTH(EDATE(B8,8))),"1 ","")

should get you

"Kay" wrote:

The dates are for different persons and I want to give them 1 every four
months; I have the cell D8:O8 with the month starting JUly and ends with JUne.
--
KK


"Sean Timmons" wrote:

So.. your spreadsheet has a list of dates, and you want to put "1" in the
cell corresponding to the day 4 months (then 8, 12, etc) later?

"Kay" wrote:

I need to actually enter the number 1 in the cell
--
KK


"Gary''s Student" wrote:

With the first date in A1, In A2 enter:

=DATE(YEAR(A1),MONTH(A1)+4,DAY(A1)) and copy down.

Note the date in A1 cannot be too late in the year.

--
Gary''s Student - gsnu200854


"Kay" wrote:

I am doing a timesheet and need to allot 1 day every four month that is 3 per
year.

I have the start date and need a formula to give one on the start month and
then 1 four month after and the other four month after that one. Any
suggestion?
--
KK