Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating
I need a formula to issue 1 day every four month starting with the month
already in a cell, Can you help. KK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating
Can you give an example?
"Kay" wrote: I need a formula to issue 1 day every four month starting with the month already in a cell, Can you help. KK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating
Your question is uncliear. If you are trying to enter months which are
spaced four mounths apart then Enter Jan in A1 and Apr in A2, highlight both and drag the fill handle down. If you are trying to increment a date not just the month label then enter the first date in A1 and =EDATE(A1,4) in cell A2 and copy the formula down. EDATE requires the attachment of the Analysis ToolPak. You can also enter a start date such as 1/15/09 in A1 and 4/15/09 in A2, highlight both and drag the fill handle down. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Kay" wrote: I need a formula to issue 1 day every four month starting with the month already in a cell, Can you help. KK |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating
I have the start date which include month day and year in a cell. I need to
issue 1 day for that month that is already in the cell and then 1 four month after and the other four month after. I have columns from january to december -- KK "Sheeloo" wrote: Can you give an example? "Kay" wrote: I need a formula to issue 1 day every four month starting with the month already in a cell, Can you help. KK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating | Excel Worksheet Functions | |||
Calculating % | Excel Worksheet Functions | |||
calculating | Excel Discussion (Misc queries) | |||
calculating | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |