Microsoft Excel #08: Working with Dates

[wweiss1082]

I am looking for a formula to calculate a due date of 20 "working days" or "week days" from a date. For example: my report is due 20 week days days from the start date of 09/01/11. Can you help? Please?

[ianherb69]

How do I calculate the difference between 2 columns of dates to find out how many days have passed?

[MultiShabeel]

its really helpfull, thank you

[Aloiseau]

how do i get excel to stop dropping the zero when i put in a certain date? Ex: I want my date to show up as 06-May and not 6-May but it refuses to keep the "0" everytime i put it in no matter what format i use. HELP!

[onyemaechi]

is it possible for excels database to actually store dates. For example I want to create a database where i enter the dates employees have been absent, or on holiday. Is it possible to enter a date and for it to be stored somewhere else automatically?

[koreyss]

Cheers, great work!!!

[pineapplesaw]

thank you you

[momo8860]

thanks allot man

your classes have too good information ,

thanks allot....

[frederickriemann]

Hey! We should be thanking you! You are very quick and prepared. Your clases are not boring at all. Thank you!

[yarkhans1]

Awesome...Very helpful...Thnx Alot

[genious4u]

its blue budy plz upload it in high quality

[noobpwnagez]

Can you tell me what should I type if I want to minus? I couldn't really see the font in youtube video, even if I had it full screen, its still blurish.. so i'm pretty much taking up these tutotrials based mostly on your voice <_<

[noobpwnagez]

Can you tell me what should I type if I want to minus? I couldn't really see the font in the youtube video, even if I had it full screen, its still blurish.. so i'm pretty much taking up these tutorials based mostly on your voice <_<

[bcccastro]

thanks for your videos, all of them were very useful....btw can u also do about pivot table???

[simonk001]

how do i add a comma to a number without getting it turned into a date?

[0311warlord]

thanks for the help i really need to brush up on my excel skills

[dsrocketman]

I think your videos are very helpful. If you would ,could you do a video on formulas. Like show us how to make up formulas and is there a chart of symbols like * means times. It would be helpful to know how to make simple and more complexed formulas. tks again.

[musiklover2]

Is there a way to get rid of all the numbers that come after the decimal point?

If it can't be answered, that's fine.

I love the tutorial and I learn a very valuable skill.

Thanks!

[freetutorials]

Yes, you can click in the cell with the number you want to format. For example, you see 9.87654 but you just want it to round off to 10. You go to FORMAT > CELLS > NUMBER > and set the decimal to however many points you want -- in this case, 0.

Let me know if that works!

[musiklover2]

It does work.

9.87654 becomes 10 years old because it does round it off to the nearest 10th, but it still I like that I know this way because it's not that huge of a disparity.

Thank you so much!

[tlcompanion]

Hey thank you for helping me,I finally caught on...

[tlcompanion]

You are to quick,slow down please...

[Miniclip420]

I didn't understand . I will try to learn it. It useful .

[dyords0115]

is the any way of having a pulldown calendar on a cell like in microsoft access that I can make also? thanks very much.

[sendmeagain]

Nice, I watched all your excel videos. Amazing, I feel I can do something like an expert. Thank you, I'll keep watching your other tutorials.

[tatabau007]

Thank you so much,

I did not use excel for a while and with your tutorials I review many of the functions that I need for a job interview.

Thanks a lot - you are great!

[freetutorials]

Well, you are very welcome. Good luck with your job interview!

[anideepa]

Thank you for all these videos. It really helps to see a demonstration rather than read from a manual!! :)

[freetutorials]

You're very welcome. That's why I do them. I have always learned more from watching and following along than reading from a book.

[jdizzyx]

i just wanted to say thank you for these videos... i have a job interview monday and it requires me to take an excel test to measure how well i do. i knew a little bit, but after watching these videos and trying the stuff myself, im compleatly confident. thank you so much.

[freetutorials]

You are most welcome. Good luck on the interview! Let me know if there's something I can help you with before Monday! :)

Robert

[bluemamba17]

You're a rare breed: a smart guy, a nice guy, a helpful guy. Thanks!

[freetutorials]

Well, thank you very much. That was sweet.

[lsbuasad]

Well done ..Boss

[sagesdragon]

Happy New year!

Yours is one of my favorite learning areas!

I am a 51 year old grandmother learning how to use the computer

and if it weren't for the tutorials that you and others take the time to put up,

I would never have felt comfortable on this machine...

I hope you realize how much you all mean to us of the "older" generation...LOL

Thanks

Sage

[freetutorials]

Thank you so much. That is by far the nicest feedback I have ever received. Please let me know if you have any specific tutorial needs and I will see what I can do.

[humanedomain]

as always THANK YOU!!!