Set a date and have other cells reference it and incease monthly?
I am inputting a date (mm/dd/yyyy), and I want that specific date to be the
intial input where other cells can reference that cell and then increase
monthly (Jan-Dec) and yearly.
For instance, if the initial date is 01/13/1985... I want the next cell the
reference that date and automatically change from 01/13/1985 to 02/13/1985
then next cell 03/13/1985 etc etc etc...
These cells may not be next to each other (side by side) throughout the
excel document.
Thank you,
Philip Johnson
|