#1
|
|||
|
|||
Excel day date month year Function
I created a spreadsheet. I want to have tabs for each month. I want to be able to enter the year in my January tab. I would like to be able to enter the year and month in their respective places and have the days of the month and the weekday automatically populated. I have been emulating another spreadsheet I have found online and can get all of this done manually but I want the date and weekdays to automatically populate. I would like the be able to change the year and have the days and weekdays automatically change. The first file (time tracing new) is what I have done manually the second one is the one which I am trying to emulate.
|
#2
|
|||
|
|||
In order to extract the day there is a function in Excel called DAY. So if we go to the function wizard, go to the DATE and TIME category you will see that there is a DAY function, and we say OK. All it asks is tell me where the serial number is or the date. We will just point it and say OK.
Last edited by Pecoflyer; 01-05-2016 at 06:25 AM. Reason: Remove comm link |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Confused about 2 defferent uses of Now Function in Excel VBA | Jercook | Excel Programming | 0 | 04-27-2015 05:33 AM |
Excel function issue | Nobody | Excel | 1 | 06-30-2014 12:26 PM |
Excel date or edate function help | JohanB26 | Excel | 2 | 07-17-2013 09:23 AM |
Excel Function | co-lay | Excel | 3 | 02-13-2012 03:46 PM |
Help! for using an appropriate function/Macro in Excel | pawan2paw | Excel | 1 | 06-04-2009 12:28 PM |