Excel auto date insert

[alliswell]

Hi everybody

Is it possible in excel to auto insert date in Column A one after other on 22 of every month, with excel formula.

Thanks n regards to everyone on mrexcel

 

[awoohaw]

Im not sure if Excel 2007 "Spills" array formulas or arrays in Curly Brackets work.
But try this formula with the CNTL-SHFT-ENTR keystroke:

=DATE(2023,{1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24},22)

(this is for 24 months begining 1JAN2023


if that doesn't work then I think you will need to drag a formula like this down how ever many rows you need:
=Date(2023,Row(Starting Cell Reference Relative Address)- (the actual number of the starting row), 22)
so, if starting at cell A2:

=Date(2023,Row(A2)-2,22)