|
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com