How to Use Date Functions in Excel

You can use a Date Function to calculate when, for example, an invoice is payable. Use the WORKDAY Function to tell you the date when work on a project phase will end. I demonstrate the Date Functions that I find most useful. Some, for example, NETWORDAYS require you to activate the Analysis ToolPak Add-in for Excel.

I invite you to visit my website - www.thecompanyrocks.com - to view all of my videos and to see the resources that I offer.

Danny Rocks
The Company Rocks

Category:

Education

Tags:

• Microsoft
• Excel
• Date
• Functions
• Serial
• Numbers
• Calculate
• Due
• Dates
• Work
• Days
• Lessons
• Tutorial
• How-to
• Software Tutorial
• Management
• Technology
• Business
• Office
• Data
• Training

[DtM2000]

Hi - Great video but I have query. How do I pull out the year only into a new cell. I.e I have 02.02.2011 and I only want to pull out the year into a new cell? I tried the left, right, middle function but this only works on text and returns the date number not date format. Thanks.

[DannyRocksExcels]

@DtM2000

Thank you! I am pleased that you like this video.

Let me help you:

1) The entry you describe 02.02.2011 is a TEXT Entry and NOT a Date Entry.

2) Dates that are entered correctly align to the RIGHT SIDE of the Cell.

3) So, change the entry to a valid date - e.g. 02/02/2100

4) To extract the Year only, use the YEAR() Function. E.g. for a Date in cell A1, in Cell B1 write = YEAR(A1)

Thanks again for contacting me.

Danny Rocks

The Company Rocks

[erodpacaon]

Help me pls

Due date Date Pay 7 4/11/11 =if(a1>b2,"delay",not delay)

i want the day to tally not the month and year. how can i do this i want to show in my excel delay and not delay only pls help me

[DannyRocksExcels]

@erodpacaon

Hello, I am filming a video to cover your question - I plan to post it tomorrow. Here are a few key items to consider. When you want to know the number of days between a Start Date and an End Date, I recommend usig the "Undocumented_ =DATEDIF() Function e.g. =DATEDIF(StartDate, EndDate, "d") The 'd" part of this function retunrs and number of "days" between, for example, Today's Date =TODAY() and the End Date - the Date that an invoice is due to be paid.

Danny Rocks

[DannyRocksExcels]

@erodpacaon As promised, I have posted my video response to (what I think you are asking for) your question. You can find it on my YouTube Channel with the title, "Create Accounts Payable Status Summary in Excel."

I used ISBLANK, a "Nested" If Formula and also SUMIF Functions in this lesson.

I hope that this helps you!

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@erodpacaon

Thanks for writing back. Please let me know how this worked out for you.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@kamikim1

Thank you for your kind words about my tutorial.

Re: Using the NOW() Function. This is a "dynamic" function which automatically updatesthe result based upon the system clock of your computer.

The easiest solution is to capture the information from NOW() and then copy that cell() and use Paste Special - Values to turn a formula into a fixed value.

I hope that this is helpful to you,

Danny Rocks

[kamikim1]

thanks for the nice tutuorial , i have created a automated worksheet which takes the date and time automatically i.e =now(), but my question is

what if i dont want to update the date and time,i would like to fill the date and time info automatically but want to keep the same date and time when the sheet is opened next itme and so on .in easy words i want no update on d&t just one time when the worksheet is opened first time.thanks