Thread: Automatic Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_10_] Michael[_10_] is offline
external usenet poster
 
Posts: 16
Default Automatic Date


Hi all,

Is it possible to have a cell say "b1" read from a
cell "A1" and automatically change to the following month.
So If say "A1" was January, I want "b1" to be february but
I need it to be calcuated by a function. To date I have
just been adding 31 days to each cell in column a which
has worked. i.e "b1" formula reads = a1+31 etc... I am
using David McRichies "Insertandfillformulas" but for some
reason it can't read column A this formula and things
aren't working !.

Thanks for your help

Regards,


Michael