Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Using a currency in the second argument of emonth

Hello, I'm trying to use a formula, with a number formatted as currency, as the second argument in the edate function. Numbers doesn't seem to be able to deal with this. When I change the format in question to number, edate works. Formt that column back to currency and edate fails. Any suggestions are welcome. Thanks.

MacBook Pro 13", macOS 10.15

Posted on Dec 30, 2019 12:28 PM

Reply
Question marked as Best reply

Posted on Dec 30, 2019 1:03 PM

Hi PhilipH56,


TRUNC worked for me

EDATE("12/30/19",TRUNC(H3,1))


quinn

Similar questions

3 replies

Using a currency in the second argument of emonth

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.