You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Mark_J_G Author

Level 1

9 points

Numbers > Date that changes each month

Hello,

I have created a budget each month but like to copy and paste the budget into a transactions tab. I just converted from Excel and I could use the following formula and each month the date would change so I could copy and paste.

DATE(YEAR(TODAY()),MONTH(TODAY()),1)

For example - If I had the equation outlined above a bill was due at the first of the month. The date would change from 5/1/2021 to 6/1/2021 once the current month changed to June.

Is there a formula that does this in Numbers?

MacBook Air 13″, macOS 11.2

Posted on Jun 2, 2021 6:38 PM

Top-ranking reply

SGIII

Level 8

35,984 points

Posted on Jun 2, 2021 8:48 PM

Mark_J_G wrote:

Hello,

DATE(YEAR(TODAY()),MONTH(TODAY()),1)

For example - If I had the equation outlined above a bill was due at the first of the month. The date would change from 5/1/2021 to 6/1/2021 once the current month changed to June.

=DATE(YEAR(TODAY()),MONTH(TODAY()),1) works on my machine. Not on yours?

View in context

Numbers > Date that changes each month

Similar questions