Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find out specific month and year
Hi
I am having Jan-2013 (month & year only) in cell A1. What I want is the month and year after certain number of months let us say 6 months in B1 (Jul-2013). What formula should I use in B1? Help please.! - via135 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find out specific month and year
"via135" wrote:
I am having Jan-2013 (month & year only) in cell A1. What I want is the month and year after certain number of months let us say 6 months in B1 (Jul-2013). What formula should I use in B1? First, I hope you should have an actual date in A1. You might have already, if Excel recognizes Jan-2013 as a date. Does ISNUMBER(A1) return TRUE? If so, simply format A1 as Custom mmm-yyyy. Then B1 would be the formula =EDATE(A1,6), formatted as Custom mmm-yyyy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Month and year from Cell containing date, month, year & time | Excel Worksheet Functions | |||
SumProduct by specific weeks of the month or year | Excel Programming | |||
SumProduct by specific weeks of the month or year | Excel Programming | |||
Calc Prorated Cost based Specific Days in a Gven Month & Year Range. | Excel Programming | |||
I need to find out the YEAR, MONTH, DAY between two dates | Excel Discussion (Misc queries) |