Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function question
Hi everyone and thanks for any help you might have. It seems like one of you
always has the answer I need! I'm running XP Pro and Office 2007 Pro. In my spreadsheet I enter an actual date in cell B5. I need a formula for cell A6 that will return the month only six months in the future. For example, the date entered in B5 is 02/15/10. The answer in A6 needs to be August, not August 15, just August. If I use B5+180, I get 08/14/10. It doesn't matter on what day of the month the initial activity occurs, the answer has to be the sixth month after the initial month of occurance. (Sorry if this is confusing, I'm trying to make it clear.) The problem with B5+180 is when B5 is the last day of the month, 180 days later may fall in the start of the seventh month, and the answer has to be the sixth month. Thanks again for any help you can offer and I look forward to hearing from you. Jim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function question
I'm running ... Office 2007 Pro.
Try this... =TEXT(EDATE(B5,6),"mmmm") -- Biff Microsoft Excel MVP "Jim Peterson" wrote in message ... Hi everyone and thanks for any help you might have. It seems like one of you always has the answer I need! I'm running XP Pro and Office 2007 Pro. In my spreadsheet I enter an actual date in cell B5. I need a formula for cell A6 that will return the month only six months in the future. For example, the date entered in B5 is 02/15/10. The answer in A6 needs to be August, not August 15, just August. If I use B5+180, I get 08/14/10. It doesn't matter on what day of the month the initial activity occurs, the answer has to be the sixth month after the initial month of occurance. (Sorry if this is confusing, I'm trying to make it clear.) The problem with B5+180 is when B5 is the last day of the month, 180 days later may fall in the start of the seventh month, and the answer has to be the sixth month. Thanks again for any help you can offer and I look forward to hearing from you. Jim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function question
=TEXT(DATE(YEAR(B5),MONTH(B5)+6,DAY(B5)),"mmmm")
"Jim Peterson" wrote: Hi everyone and thanks for any help you might have. It seems like one of you always has the answer I need! I'm running XP Pro and Office 2007 Pro. In my spreadsheet I enter an actual date in cell B5. I need a formula for cell A6 that will return the month only six months in the future. For example, the date entered in B5 is 02/15/10. The answer in A6 needs to be August, not August 15, just August. If I use B5+180, I get 08/14/10. It doesn't matter on what day of the month the initial activity occurs, the answer has to be the sixth month after the initial month of occurance. (Sorry if this is confusing, I'm trying to make it clear.) The problem with B5+180 is when B5 is the last day of the month, 180 days later may fall in the start of the seventh month, and the answer has to be the sixth month. Thanks again for any help you can offer and I look forward to hearing from you. Jim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function question
Thanks for the formula. I plugged it in and it worked OK except when the
originating month had 31 days (e.g. March) and the answer month only had 30 days (e.g. September). In that instance it would return an answer of October instead of the correct answer of September. However, T. Valko's formula seems to be working correctly for what I need. Thanks again for the suggestion though. Jim "Teethless mama" wrote: =TEXT(DATE(YEAR(B5),MONTH(B5)+6,DAY(B5)),"mmmm") "Jim Peterson" wrote: Hi everyone and thanks for any help you might have. It seems like one of you always has the answer I need! I'm running XP Pro and Office 2007 Pro. In my spreadsheet I enter an actual date in cell B5. I need a formula for cell A6 that will return the month only six months in the future. For example, the date entered in B5 is 02/15/10. The answer in A6 needs to be August, not August 15, just August. If I use B5+180, I get 08/14/10. It doesn't matter on what day of the month the initial activity occurs, the answer has to be the sixth month after the initial month of occurance. (Sorry if this is confusing, I'm trying to make it clear.) The problem with B5+180 is when B5 is the last day of the month, 180 days later may fall in the start of the seventh month, and the answer has to be the sixth month. Thanks again for any help you can offer and I look forward to hearing from you. Jim |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function question
Hey thanks for the formula T. Valko. It seems to be doing exactly what I need.
I really appreciate the help. Jim "T. Valko" wrote: I'm running ... Office 2007 Pro. Try this... =TEXT(EDATE(B5,6),"mmmm") -- Biff Microsoft Excel MVP "Jim Peterson" wrote in message ... Hi everyone and thanks for any help you might have. It seems like one of you always has the answer I need! I'm running XP Pro and Office 2007 Pro. In my spreadsheet I enter an actual date in cell B5. I need a formula for cell A6 that will return the month only six months in the future. For example, the date entered in B5 is 02/15/10. The answer in A6 needs to be August, not August 15, just August. If I use B5+180, I get 08/14/10. It doesn't matter on what day of the month the initial activity occurs, the answer has to be the sixth month after the initial month of occurance. (Sorry if this is confusing, I'm trying to make it clear.) The problem with B5+180 is when B5 is the last day of the month, 180 days later may fall in the start of the seventh month, and the answer has to be the sixth month. Thanks again for any help you can offer and I look forward to hearing from you. Jim . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function question
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jim Peterson" wrote in message ... Hey thanks for the formula T. Valko. It seems to be doing exactly what I need. I really appreciate the help. Jim "T. Valko" wrote: I'm running ... Office 2007 Pro. Try this... =TEXT(EDATE(B5,6),"mmmm") -- Biff Microsoft Excel MVP "Jim Peterson" wrote in message ... Hi everyone and thanks for any help you might have. It seems like one of you always has the answer I need! I'm running XP Pro and Office 2007 Pro. In my spreadsheet I enter an actual date in cell B5. I need a formula for cell A6 that will return the month only six months in the future. For example, the date entered in B5 is 02/15/10. The answer in A6 needs to be August, not August 15, just August. If I use B5+180, I get 08/14/10. It doesn't matter on what day of the month the initial activity occurs, the answer has to be the sixth month after the initial month of occurance. (Sorry if this is confusing, I'm trying to make it clear.) The problem with B5+180 is when B5 is the last day of the month, 180 days later may fall in the start of the seventh month, and the answer has to be the sixth month. Thanks again for any help you can offer and I look forward to hearing from you. Jim . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question About Date Function | Excel Worksheet Functions | |||
Date function question | Excel Discussion (Misc queries) | |||
IF Function with Date revised question | Excel Worksheet Functions | |||
Another date function question | Excel Worksheet Functions | |||
Another date function question | Excel Worksheet Functions |