Excel: Dates

I need the dates 01/01/17, 06/30/17, and 12/31/17 in cells A1, A2, and A3 to automatically adjust to 01/01/18, 06/30/18, and 12/31/18 next year, without having to manually enter them again.

These dates can't be in text format, because I need to use the dates in formula calculations.

Thank you!
Cactus1994OwnerAsked:
Who is Participating?
 
AlanConsultantCommented:
Hi,

A1 = DATE(YEAR(NOW()),1,1)
A2 = DATE(YEAR(NOW()),6,30)
A3 = DATE(YEAR(NOW()),12,31)


Alan.
0
 
Cactus1994OwnerAuthor Commented:
Thank you!
0
 
AlanConsultantCommented:
You're most welcome.

Alan.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.