Excel: Dates

Cactus1993
Cactus1993 used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant
Commented:
Hi,

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


Alan.
Cactus1993Owner

Author

Commented:
Thank you!
AlanConsultant

Commented:
You're most welcome.

Alan.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial