|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 21st, 2009, 09:02 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems
Maybe I am not explaining properly what I need. This is what I need. I am
doing a timesheet and have a cell with the start date (Month, day and Year) I am trying to give 1 day every four month (That is 3 for the year-1 every four months). I need to issued the first day the month of the start date. I have cell D8:O8 Starting with July and ending with June and need the day to enter below. What formula can I use to issue the days? -- KK 
|
|
#2
May 21st, 2009, 10:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problems
The example given is not clear enough to figure out an answer. Can yo post a
sample of what the result would be if everything was working properly? -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Kay" wrote: Maybe I am not explaining properly what I need. This is what I need. I am doing a timesheet and have a cell with the start date (Month, day and Year) I am trying to give 1 day every four month (That is 3 for the year-1 every four months). I need to issued the first day the month of the start date. I have cell D8:O8 Starting with July and ending with June and need the day to enter below. What formula can I use to issue the days? -- KK
|
|
#3
May 22nd, 2009, 02:37 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problems
start date: 05/26/06( this is in cell k3)
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun ( these are from cell D8:O8) 1 1 1 want to issue 1 day every 4 months as above using the start date. -- KK "PJFry" wrote: The example given is not clear enough to figure out an answer. Can yo post a sample of what the result would be if everything was working properly? -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Kay" wrote: Maybe I am not explaining properly what I need. This is what I need. I am doing a timesheet and have a cell with the start date (Month, day and Year) I am trying to give 1 day every four month (That is 3 for the year-1 every four months). I need to issued the first day the month of the start date. I have cell D8:O8 Starting with July and ending with June and need the day to enter below. What formula can I use to issue the days? -- KK
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
