Variable date

This puts the function, @NOW, in the current cell and formats the range to DD-MMM-YY. Whenever you call the worksheet up, the current date will appear in that cell, and change from day to day.

The macro sets the column width to 10 so the date will fit in one column. The macro pauses to allow the user to change the column width if desired (use the arrow keys or enter a number). Finally press (ENTER) to accept the width.

1-2-3 Macro: '/RFD1~@NOW~/WCS10~/WCS

System Macro Version:

Comment: 123 Variable Date

Contents: {ENTER}{MENU}rfd1{ENTER}@now {ENTER}{MENU}wcs10{ENTER}{MENU}wcs