PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel New Users > how to calculate a month without the full date?

Reply
Page 1 of 2 1 2
Thread Tools Rate Thread

how to calculate a month without the full date?

 
 
=?Utf-8?B?SmFyZWQ=?=
Guest
Posts: n/a
 
      12th Jun 2006
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
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      12th Jun 2006
=TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jared" <(E-Mail Removed)> wrote in message
news:472DD1D6-DA32-4669-9FFC-(E-Mail Removed)...
> 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
 
Reply With Quote
 
Bondi
Guest
Posts: n/a
 
      12th Jun 2006

Bob Phillips wrote:
> =TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm")
>
> --
> HTH
>
> Bob Phillips
>
Hi,

In case you run in to February you should change 30 to 28 and 2 to 5.

Regards,
Bondi
 
Reply With Quote
 
Guest
Posts: n/a
 
      12th Jun 2006
Hi

Nice one Bob!!
On my machine, though, it falls over on February. This should help:
=TEXT(DATEVALUE("28-"&A1&"-"&YEAR(TODAY()))+5,"mmmm")

Andy.

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:e$(E-Mail Removed)...
> =TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm")
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Jared" <(E-Mail Removed)> wrote in message
> news:472DD1D6-DA32-4669-9FFC-(E-Mail Removed)...
>> 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
>
>
 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      12th Jun 2006
Good point. I originally tried 32 without the add, but DateValue didn't like
it. Forgot Feb on my final try.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bondi" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Bob Phillips wrote:
> > =TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm")
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> Hi,
>
> In case you run in to February you should change 30 to 28 and 2 to 5.
>
> Regards,
> Bondi
>
 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      12th Jun 2006
Hi Andy,

You did the same as Bondi, added 5. Why 5? I would have added 4 (if I had
remembered Feb <g>).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<Andy> wrote in message news:(E-Mail Removed)...
> Hi
>
> Nice one Bob!!
> On my machine, though, it falls over on February. This should help:
> =TEXT(DATEVALUE("28-"&A1&"-"&YEAR(TODAY()))+5,"mmmm")
>
> Andy.
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:e$(E-Mail Removed)...
> > =TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm")
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Jared" <(E-Mail Removed)> wrote in message
> > news:472DD1D6-DA32-4669-9FFC-(E-Mail Removed)...
> >> 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
> >
> >
>
>
 
Reply With Quote
 
=?Utf-8?B?Um9uIENvZGVycmU=?=
Guest
Posts: n/a
 
      12th Jun 2006
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" <(E-Mail Removed)> wrote in message
> news:472DD1D6-DA32-4669-9FFC-(E-Mail Removed)...
> > 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
>
>
>
 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      12th Jun 2006
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" <(E-Mail Removed)> wrote in message
news:2BEC2572-9674-4AE1-BC96-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:472DD1D6-DA32-4669-9FFC-(E-Mail Removed)...
> > > 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
> >
> >
> >
 
Reply With Quote
 
Guest
Posts: n/a
 
      12th Jun 2006
Hi Bob,

Why 5? Erm, why not? Seems strange, though, that Bondi chose 5 too!! Just
making sure to give it enough! <vbg>

Andy.

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Andy,
>
> You did the same as Bondi, added 5. Why 5? I would have added 4 (if I had
> remembered Feb <g>).
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> <Andy> wrote in message news:(E-Mail Removed)...
>> Hi
>>
>> Nice one Bob!!
>> On my machine, though, it falls over on February. This should help:
>> =TEXT(DATEVALUE("28-"&A1&"-"&YEAR(TODAY()))+5,"mmmm")
>>
>> Andy.
>>
>> "Bob Phillips" <(E-Mail Removed)> wrote in message
>> news:e$(E-Mail Removed)...
>> > =TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm")
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > (replace somewhere in email address with gmail if mailing direct)
>> >
>> > "Jared" <(E-Mail Removed)> wrote in message
>> > news:472DD1D6-DA32-4669-9FFC-(E-Mail Removed)...
>> >> 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
>> >
>> >
>>
>>
>
>
 
Reply With Quote
 
=?Utf-8?B?SmFyZWQ=?=
Guest
Posts: n/a
 
      12th Jun 2006
Thanks it worked!!!!




"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" <(E-Mail Removed)> wrote in message
> news:472DD1D6-DA32-4669-9FFC-(E-Mail Removed)...
> > 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
>
>
>
 
Reply With Quote
 
 
 
Reply
Page 1 of 2 1 2

« cell format | Pivot Table Question »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate the weekday of last FULL week of month Pete_UK Microsoft Excel Discussion 6 20th Dec 2007 09:50 PM
Date differential between a full date and a date that has a year and month. scottypws Microsoft Access Queries 5 23rd Nov 2007 05:47 PM
How to calculate the end date of a month? =?Utf-8?B?RXJpYw==?= Microsoft Access VBA Modules 2 14th Nov 2006 03:35 PM
Calculate 1st of month date from existing date. Jim15 Microsoft Excel Misc 1 9th Jan 2006 10:05 PM
Calculate month-end date from date in adjacent cell? =?Utf-8?B?TWF0dCBEIEZyYW5jaXM=?= Microsoft Excel Worksheet Functions 4 19th May 2005 04:55 AM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 06:37 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top