how to calculate a month without the full date?
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" wrote in message
...
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 ...
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" wrote in message
...
=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
|