Can someone please explain what the 29 means?

The MONTH function returns a number between 1 and 12 indicating the month
number. Multiplying each of those by 29 will give a series of values 29, 58,
87, ..., 219, 348. Each of these is treated as a date (day of year of 1900),
and thus TEXT with the "mmmm" parameter will return the month name for that
date, and you'll get "January", "February"...."December".

To see this in action, enter =ROW()*29 in A1 and =TEXT(A1,"mmmm") in B1 and
fill down to row 12. You'll get month names in B1:B12.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Cavy" wrote in message
...
This formula is working really well for me.

Can someone please explain what the 29 means?

Many thanks!

"daddylonglegs" wrote:


If you don't mind the result as text, rather than a formatted date you
could use

=TEXT((MONTH(TODAY())+1)*29,"mmmm")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=544079