Hi,

Before you enter the formula change the cell format to General, if you are
seeing the formula is may be because the format is Text. Also, try choosing
Tools, Options, View and unchecking Formulas.

FYI - =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"mmmm yyyy")

If you want to display the date in a mmmm yyyy format you don't need to use
the TEXT function, just enter =TODAY() in the cell and choose Format, Cells,
Number tab, Custom, and enter mmmm yyyy in the Type box.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Rachel Costanza" wrote:

Hello,

When I try to put date functions in a template exported from business
objects the functions do not work. For example if in cell A1 I use
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"mmmm yyyy") that is what shows up
in cell A1. I have tried to change the cell formats to all available options
and still the date does not display. Any ideas?

Many thanks in advance!

Rachel Costanza