Numbers > Date that changes each month

Question

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

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

36,092 points

Jun 2, 2021 8:48 PM in response to Mark_J_G

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?

SG

Reply

Answer 2

Mark_J_G Author

Level 1

9 points

Jun 3, 2021 11:26 AM in response to SGIII

Hello,

It is working now. I think maybe the formula from Excel wasn't working correctly. When I copied and pasted the formula again it worked. Sorry to bother you!

Reply