how to create predefined series of texts like weekdays,months and
 

please help i want to create the above in excel

how to create predefined series of texts like weekdays,months and
 

Hi,

Use excel date and time formulas for this. For eg today's date in cell A2 of
sheet 1
=TODAY() will return the current date accordingly you can use other functions.
--
_______________________
Click "Yes" button if it helps
________
Thanks
Suleman Peerzade


"ash" wrote:

please help i want to create the above in excel

how to create predefined series of texts like weekdays,months and
 

Weekdays, months should be default in ToolsOptionsCustom Lists

But if not, create a new list by clicking on New and entering your
comma-delimited list then hit Add button.


Gord Dibben MS Excel MVP

On Sat, 17 Jan 2009 00:21:01 -0800, ash
wrote:

please help i want to create the above in excel