| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF giving me 0 | Excel Discussion (Misc queries) | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
Linear Mode
