How to find the day when you enter a date in excel

try:

Please Login or Register  to view this content.

with your date in A1, this will show Friday (for today).

in case you want the day's number,

Please Login or Register  to view this content.

the other thing you can do is to format the cell (where date is being entered) in such a way that the Date and Day are both displayed simultaneously within the same cell. in order to do that, just right-click on the cell where date will be entered, select Format Cells, select Date, and select the formatting from the Type list where both Day and Date are being displayed. or, in the same Format Cells window, you can choose to create a Custom format, and Type could be "dddd mm-dd-yyyy" (without the quotes). this way, you would not need to have a formula in another cell.

1194

Something like this?

=TEXT(TODAY(),"dddd")

Thanks,

I'm sorry, i should have been more clear with what i was asking. I have a template which has over 1000 row of data. It has dates and day. I want to automate the worksheet. If i enter just the year in one cell the entire worksheet should change to the date it has say 1 jan, 2 jan, 3 jan etc with day also displayed in a cell.

Hope this will help you to be able to help me. Maybe if may require and if statement "If year such, then day 1 equal Jan 1 and Day equals Tuesday"

Thanks