Home |
Search |
Today's Posts |
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to calculate a month without the full date?
Yes. Perfet!
Thanks "Ron Coderre" wrote: Here you go....Try this: A1: (a month name) The name of the previous month B1: =TEXT(DATEVALUE("1-"&A1&"-"&YEAR(TODAY()))-1,"mmmm") Does that help? *********** Regards, Ron XL2002, WinXP "Jared" wrote: Thanks you all for everything. Now how do i do this backwards? I input May The resolt : April? Jared "Bob Phillips" wrote: We can Ron, but I am not a great believer in defaulting, it invariably comes back and bites you when you least expect it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Ron Coderre" wrote in message ... Bob I think we can just let Excel default the year in (since YEAR doesn't seem to matter in this case): B1: =TEXT(DATEVALUE("28-"&A1)+4,"mmmm") *********** Regards, Ron XL2002, WinXP "Bob Phillips" wrote: =TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jared" wrote in message ... This might be a stupid question. i have a cell (A1), with a month's name: "April" How do i use a formula so cell B1 will show "May" and when i change A1 to "June" Cell B1 will show "July"? Basically a calulation but without a full date Thanks Jared |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating month of present date | Excel Discussion (Misc queries) | |||
extract the month of a date | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
calculate anniversary of date after specified date | Excel Worksheet Functions | |||
calculate no. of years between a date and today's date | Excel Worksheet Functions |