B
Bruce Roberson
+"Estimated as of : "&@STRING(@MONTH(@NOW),0)&"/"&@STRING(@DAY(@NOW),0)&"/"&@STRING(@YEAR(@NOW)+1900,0)
Excel is having a hissy fit with my attempt to convert this QPW string formula to a suitable Excel substitute. I know to substitue fixed for @string. But things like @month@now to me ought to be easy to say month(now), and @Day(@now) ought to translate to day(now), but none of this seems to be helping.
The net result of the above formula should read as follows: Estimated as of 7/20/03, and the date should of course change as the date changes.
Excel is having a hissy fit with my attempt to convert this QPW string formula to a suitable Excel substitute. I know to substitue fixed for @string. But things like @month@now to me ought to be easy to say month(now), and @Day(@now) ought to translate to day(now), but none of this seems to be helping.
The net result of the above formula should read as follows: Estimated as of 7/20/03, and the date should of course change as the date changes.