A Alex Jan 11, 2005 #1 Hi, I have a cell A1 which is formatted mmm-yy. I want B1 to be Ai plus the next month and so on. How do I format that please Alex
Hi, I have a cell A1 which is formatted mmm-yy. I want B1 to be Ai plus the next month and so on. How do I format that please Alex
A Alex Jan 11, 2005 #3 Thanks Alex Harald Staff said: Hi Alex =DATE(YEAR(A1),MONTH(A1)+1,1) HTH. Best wishes Harald Click to expand...
Thanks Alex Harald Staff said: Hi Alex =DATE(YEAR(A1),MONTH(A1)+1,1) HTH. Best wishes Harald Click to expand...