Microsoft Excel Adding Years, Months, and Days to Date
Ғылым және технология
www.ReportingGuru.com produced this video. This video shows how to add years, months and days to a date. Email us at ReportingHelp@ReportingGuru.com if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759
Пікірлер: 92
I must thank you for this. I was looking all over for this and low and behold, here it is. I update my budget every month and to have to change the months every month is a drag. Now when I update the first cell, all the months will be updated as well as the years. Thanks again!!!
@ReportingGuru
3 жыл бұрын
You are welcome. Thanks for watching our Excel videos and the great feedback!!
Lady, your instruction was outstanding. It was clear and procedurally coherent. Have a phenomenal day but even better weekend.
Thanks, had 4000 dates to change and saved me a bucket of time. have an awesome day soul sister. :-)
@ReportingGuru
9 жыл бұрын
rossalchemist Thanks for the great feedback. We love being able to people with Reports!!
Thanks a lot.. I'm an accountant I have to calculate all the employees date of retirement this formula helped me..
@ReportingGuru
3 жыл бұрын
Thanks for the feedback. Glad you liked our Excel Training Videos.
perfect..! This is what I needed. Than you very much kind lady :)
@ReportingGuru
2 жыл бұрын
Thanks for the feedback. Glad you liked our Excel Reporting videos.
You help me alot
@ReportingGuru
2 ай бұрын
Thanks for watching our Excel Reporting Videos.
Perfect!!!! Thank you so much !! Easy to understand and on point !!
@ReportingGuru
8 жыл бұрын
+jerdans Glad our Microsoft Excel Videos helped!!
Thank you, just what I was looking for.
@ReportingGuru
7 жыл бұрын
Glad our Excel Videos could help out.
Thank you, just what I needed.
@ReportingGuru
8 жыл бұрын
+James Creasey Glad our videos helped.
That was very useful, thank you!
@ReportingGuru
5 жыл бұрын
Glad our Microsoft Excel video helped!!
Thank You Mam. It's very useful
THANKS MAM..VERY HELPFUL TO ME
Hi , thank you for your this!! is there a way I can just display the year and month like JUNE 2017 without the day? and also is there a way of working an IF function in there to say If the date is equal to or more than the 15th of that month then display that Month and year eg. 22/6/2017 = JUNE 2017 , but if its under the 15th of that month , display the previous month eg. 6/6/ 2017 = MAY 2017. hope this makes sense and really hope you can help!
thank you so much ♡
@ReportingGuru
2 жыл бұрын
Thanks for the feedback. Glad you liked our Excel videos.
Thanks, this video helped a lot and saved time.
@ReportingGuru
4 жыл бұрын
Thanks for the feedback. Glad our Excel Videos helped out.
Thank you so much, Just what I was looking for
@ReportingGuru
3 жыл бұрын
Glad you liked our Excel videos. Thanks for the feedback.
This is awesome, thank you soooo much!
@ReportingGuru
6 жыл бұрын
Thanks Laura for the feedback. Glad you liked our Excel videos!!
@LauraEllen999
6 жыл бұрын
It was EXACTLY the formula I was looking for. So grateful you made this. Thanks again!
Thank you, it was a great help.
@ReportingGuru
6 жыл бұрын
Thanks for watching our Excel videos. I'm glad the videos were helpful.
@ReportingGuru
5 жыл бұрын
Glad our Excel video for adding years, months, and days helped out.
Thanq so much, this is very useful in our work, u made it very easy
@ReportingGuru
7 жыл бұрын
Glad our Excel videos could help you out!!
Great Video, Very Usefull
@ReportingGuru
6 жыл бұрын
Glad our Excel Videos helped!!
Thanks. That helped.
@ReportingGuru
3 жыл бұрын
Thanks for watching our Microsoft Excel Videos. I'm glad they helped.
Thank U so much ❤️
@ReportingGuru
3 жыл бұрын
Thanks for watching our Excel videos. Glad it helped.
Thank you very much!!!
@ReportingGuru
8 жыл бұрын
+Drew Walter Glad our Excel Reporting Videos helped out!!
Thank you 👍
@ReportingGuru
2 жыл бұрын
Glad you liked our Excel videos.
Nice & Clear.
@ReportingGuru
9 жыл бұрын
Thanks!!
Thank you very use full sister. Thank you
@ReportingGuru
4 жыл бұрын
You are welcome brother. Glad our Excel reporting videos helped.
Thank you :)
@ReportingGuru
7 жыл бұрын
Glad our Excel Videos helped :-)
Outstanding! Great Help.. I want to identify events which are in range to include + 4 months AND today - 4 months. Anybody have a suggestion? thanks!
What do you do if you just want to change the original date, not create a new one? I have a series of bill due dates and every month I have been going in and changing them by hand individually. How would I tell excel to just add 1 month on to each date?
Thank you
@ReportingGuru
3 жыл бұрын
You are welcome. Thanks for watching are Excel Reporting Videos.
Excellent simple easy to understand, sweet voice, Please upload as many on Excel, Q: formula does not work with decimal years or decimal months or decimal days? Can you advise an alternative, simple way? Date 13/04/2017 Add 10.6 years Answer?
Thank you so much
@ReportingGuru
7 жыл бұрын
Glad our Excel videos helped.
@fishingegypt8882
7 жыл бұрын
Always
I have and date and month only, e.g. 01/Jan in excel i want it to appear with a year so 01.01.17 and i have random dates with the same year how can i change this? thanks
THANK YOU
@ReportingGuru
7 жыл бұрын
Glad our videos helped!!
omg - :) how to i thank you mam -
@ReportingGuru
2 жыл бұрын
Thanks for the feedback. Glad you liked our Excel Reporting Videos.
you rock you rock you rock
@ReportingGuru
6 жыл бұрын
Glad our Excel videos could help
Tqvm
@ReportingGuru
3 жыл бұрын
Thanks for the feedback on our Excel Videos. Glad you liked them.
Thanks.
@ReportingGuru
8 жыл бұрын
+abbas shareghi . No problem. We love it that people love our reporting videos.
how i can calculate year, month, day + year, month, day =!! ???year ??month ???day . i want like this case
What if the years to be added is 3.5 years ?
if shld add 390 days then ?
I have a formula that I cant figure out, can I private message you?
@ReportingGuru
8 жыл бұрын
+Nick Santangelo You can email us at ReportingHelp@ReportingGuru.com
A great video - a subject that can get surprisingly difficult - I have awarded this video the Excel Video of the Week on the www.improveyourexcel.com website. I hope this helps you build your subscriber base.
Tryed this 100 times now.. Does not work... just keeps telling me There a problem with the formula and i should add a apostrophe.... -.-
@ReportingGuru
7 жыл бұрын
Try putting in Note Pad before putting in Excel. There be something you are missing and sometimes doing outside of Excel first helps.
The formula for month is not good. For example if I add 1 month to 31.05.2018, it gives 01.07.2018. The answer that I want is 30.06.2018 since 31.06.2018 doesn't exist.
@ReportingGuru
6 жыл бұрын
Put your dates in MM/DD/YYYY format.
@ravisolanki5590
5 жыл бұрын
Agree not working even if use in MMDDYyyy form
I keep getting you Enter too many arguments to this function
@ReportingGuru
4 жыл бұрын
Thanks for watching our Excel videos. I recommend putting the formula in Notepad first so that you can easily identify what goes where. Then paste that formula into Excel.
But deag option is not clear date
@ReportingGuru
4 жыл бұрын
Thanks for watching our Excel Videos. Not sure I understand your questions.
Why do I just get a bunch of ###### ??
@ReportingGuru
4 жыл бұрын
Thanks for watching our Excel Videos. If you expand the column, it will show the values instead of ######
@pinkie09999
4 жыл бұрын
It works for me, maybe make sure you have the parentheses correctly?
Incorrect errors popung out
@ReportingGuru
3 ай бұрын
Thanks for watching our Excel Reporting Videos.