Cactus1993
asked on
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!
These dates can't be in text format, because I need to use the dates in formula calculations.
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're most welcome.
Alan.
Alan.
ASKER