View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keeprogoal
 
Posts: n/a
Default 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