Thank you so much for sharing! Do you by chance have a video, or could you possibly create on that can show me how to add 1 to a number on a daily basis in a specific range of cells? for example if I enter the number 74 in a specific field... tomorrow the number would show 75 and the next day 76 and so on? I really need this to create a chart for work. Any guidance would be greatly appreciated! I have been trying to figure this out for two days now :(
Hi Jon, Is there a formula / rule to have a cell calculate a specific date based on another date entered into a cell plus 15 days? We would ideally want the calculated date to always default to the Friday before a weekend, if the 15th day from the originally entered date falls on a weekend. Is this possible?
Excellente! Can you help me create a macro that copies values to a tab based on date? Example: In a record sheet we have values from January to December by date. Depending on the registration date, the macro should copy January values to January tab, February values to February tab, etc.Thanks
Hi Jon, I am looking to simply increment or decrement the date in a single cell with a keyboard press. I seem to remember being able to do this but have forgotten how. The plus/minus sign should work but does not. Must be a simple setting ? I would greatly appreciate any light you could shed .
How do you keep track of days in stock. For example if you bought goods on 1/2/16 and you wanted to know how many days you have had this stock in inventory. How would you do that
I was doing the last attempt for my ITE exam and this adding without function step was pushing me in a B. I had to put =G4+14 and I was always pressing sum. Anyway thanks I got 100
thank u very much but can u help me? I want to put dates for 4 days (mon,tue,wed,thu) for every week and i dont want (fri, sat, sun) how can i do that ?
Hi Jon, how would I add days to certain dates using if functions? For example if I wanted to add 45 days to half of the cells and 60 days to the other half. How would I do this?
Hi mate, Im tryin to use "todays date" in a formulas. for example I am using an order date say 6/1/2020 and only have 15 days to produce the product. I want a cell that shows how many days are left of the 15 days. can you help?
Sir, i have problem. I need to put several expenses descriptions in a same date and when i filter the date i need to those descriptions separately how can i make that possible
Great video. - was trying to sign up for the webinar on 29 December but somehow lost the link - could you pls send me the link so I can register. Thanks and wish you a great New year 2018
Good Afternoon, Can you please assist me, i have been watching a number of your videos to assist me but I cant seem to find what I'm looking for now, I have a sheet that has 2 dates, the first date gets recorded, and a few days later the second date will be recorded depending on the employees I have. What i need is to count the days from the first date continuously, and once the second date is recorded the days needs to stop counting??? PLEASE ASSIST IF POSSIBLE
I need to add a certain amount of years. I have a year(2018) in one cell and I need to add the number in another cell (5) to that year to show 2023 in the third cell. My dilemma seams to be with that number 5. In excel I got that number 5 with a VLOOKUP Formula so I am not sure if the Date formula is able to read that cell as "5" or if it's trying to read the formula. The Date formula keeps coming back with odd years. Any suggestions?
Hi Excel Campus, I tried to achieve 12 dates from descending coulombs the best I could come up is still the same date? Any idea what else I can do or can someone team view and fix the problem? My dates are suposed to be 1-3-2019 then under neath 1-4-2019 then under that cell 1-5-2019 I tried series and flash fill and plus nothing is working
HELLO SIR, COULD YOU HELP ME PLEASE? I WANT THE DATE CHANGE EVERY DAY FOR EXAMPLE: I PUT 01-JAN-2020 THEN NEXT DAY WHEN I OPEN THE EXCEL FILE THE DATE MUST BE CHANGE TO 02-JAN-2020 OR AFTER 5 DAYS I OPEN IT THE DATE MUST BE CHANGE TO 06-JAN-2020 THANK YOU SIR.
Good video, but can I ask a question? In my work we have Service Levels. So when request comes in, we have 28 days to deal with it. So say if I’m expecting a request from Joe Bloggs, when I enter into B2 Cell =SUM(A1+28) it brings up 28 Jan 1900 cause I have no information in A1 yet. How do I make that B2 is Blank until I put the request date into A1
how would I make a formula same as this, but I will assign also another cell not only the cell that I had to put the dates, but it will depend on 2 cells. Like if I assign A1 as the date a person should start a day for his quarantine, then the second cell will automatically, let say A2 will appear his 7day of quarantine as HARD QUARANTINE. And the formula for A2 will be =A1+7. Then for the 3rd cell this will assign for his 8th day to 14th day quarantine as SOFT QUARANTINE. The formula. will. appear as =A1+14 for cell A3. but what if the persons are quarantined has different quarantine days. Example, ASIAN people need TO be quarantine for 14 days for HARD QUARANTINE and European people only needs 10 days for HARD QUARANTINE. My question now is how can I assign different formula for ASIAN and EUROPEAN when entering a certain date for a ASIAN people then automatically produce a formula for ASIAN only as well a formula also if the person is EUROPEAN.
Great question Marc! We can use the WORKDAY function for this. The WORKDAY function has 3 arguments that allow us to specify the Start Date, Number of Days to Add, and Holidays. The Holidays argument is optional and is typically stored as a list of dates in cells. If cell A2 contains today's date (12/27/2017), then the following formula would return 20 workdays from today with a result of 1/24/2018. =WORKDAY(A2,20) We can also use the NETWORKDAYS function to calculate the number of workdays between two dates. I will do a followup video on these functions. They are great ones to know. Thanks again and have a Happy New Year! :-)
I want formula or solutions for auto fill renew date/ valid upto in front of start date eg. 20/04/2018, 3/8/2020 , 25/7/2014 it becomes 19/04/2020, 2/8/2021 & 24/7/2020 year must be current year but if start date is current year then it will be next year
Seems like a very flawed method of dealing with dates. How would you add a month to this? I'm just looking for a way to increase a value of dates (due dates for bills) without having to type them in manually every month and it doesn't really seem to be possible from everything I've seen so far without making some big convoluted mess out of things. It should be as simple as selecting the dates and clicking a button and telling it to add 1 month to the date. I guess this is too much to ask from a company that thinks the Ribbon bar is a good idea. I don't really care if it's there, but removing the drop down menus that made 99% of the things you need to do much easier than the ribbon bar was just idiotic.
I have to comment because i spent a good hour trying to figure it out and reading all the text in the formula bars option. Such BS when you realize how simplistic the solution to a problem is.
It's kind of ridiculous for such mature software to not have functions to convert or scale basic values according to their type. It really should be possible to use =A2+DAYS(14) the fact is you have know that date values are days since 1900, is just poor design. Thanks for explaining
Great video, thanks. Using it to calculate when bills are due.
very simply and easily told sir, thanks
You're welcome, Manoj! :)
Great video saved me hours of work thanks!
Thank you !!! You were a huge help
Thank you!!
Thank u so muchh... It's a huge help thanks a lot.............🥰🥰
Thank you. Very helpful video.
Sir Thanks for sharing your knowledge
This was super helpful. Thank you!
Thanks, Sir you save my day!
Thanks mate
Great examples...thanks Jon!
Fantastic examples. Thanks.
Thanks
Jon, simple but excellent as always
Thank you Tudor!
Thank you, your videos are really helpful!
Thanks
Thank you so much for sharing! Do you by chance have a video, or could you possibly create on that can show me how to add 1 to a number on a daily basis in a specific range of cells? for example if I enter the number 74 in a specific field... tomorrow the number would show 75 and the next day 76 and so on? I really need this to create a chart for work. Any guidance would be greatly appreciated! I have been trying to figure this out for two days now :(
✔thanks
Pls how to make 30 sheets datewise
Thankyou
Hi Jon, Is there a formula / rule to have a cell calculate a specific date based on another date entered into a cell plus 15 days? We would ideally want the calculated date to always default to the Friday before a weekend, if the 15th day from the originally entered date falls on a weekend. Is this possible?
Hi Jon, is there a formula or rule that will allow you to subtract 5 yrs and 1 day from a specific date?
happy holiday sir
Thnku u john great tips learning alot from your vedios i need tips on how to create a best sales report for travel industry plz help !
I know this is a few years late, but i have an issue that the date keeps going back to 1/1/1900 everytime i try to add to the dates. any help?
same
Great video Jon, do you have a video that shows how to use a formula to answer the question of how many days between two dates?
Excellente!
Can you help me create a macro that copies values to a tab based on date? Example: In a record sheet we have values from January to December by date. Depending on the registration date, the macro should copy January values to January tab, February values to February tab, etc.Thanks
how about adding days of the week against each date e.g, Monday, tuesday etc?
Hi Jon, I am looking to simply increment or decrement the date in a single cell with a keyboard press. I seem to remember being able to do this but have forgotten how. The plus/minus sign should work but does not. Must be a simple setting ? I would greatly appreciate any light you could shed .
Need to apply the code in filtered cell
Super sir
Hi Jon, how about days left then removing 1 day in between those day
what about dates before Chirist in timeline?
How do you keep track of days in stock. For example if you bought goods on 1/2/16 and you wanted to know how many days you have had this stock in inventory. How would you do that
I was doing the last attempt for my ITE exam and this adding without function step was pushing me in a B. I had to put =G4+14 and I was always pressing sum. Anyway thanks I got 100
thank u very much
but can u help me?
I want to put dates for 4 days (mon,tue,wed,thu) for every week and i dont want (fri, sat, sun)
how can i do that ?
How do you do this in google sheets?!
Hi Jon, how would I add days to certain dates using if functions? For example if I wanted to add 45 days to half of the cells and 60 days to the other half. How would I do this?
Macros are interesting
Hi mate, Im tryin to use "todays date" in a formulas. for example I am using an order date say 6/1/2020 and only have 15 days to produce the product. I want a cell that shows how many days are left of the 15 days. can you help?
Sir, i have problem. I need to put several expenses descriptions in a same date and when i filter the date i need to those descriptions separately how can i make that possible
Great video. - was trying to sign up for the webinar on 29 December but somehow lost the link - could you pls send me the link so I can register. Thanks and wish you a great New year 2018
Good Afternoon,
Can you please assist me, i have been watching a number of your videos to assist me but I cant seem to find what I'm looking for now, I have a sheet that has 2 dates, the first date gets recorded, and a few days later the second date will be recorded depending on the employees I have. What i need is to count the days from the first date continuously, and once the second date is recorded the days needs to stop counting???
PLEASE ASSIST IF POSSIBLE
I need to add a certain amount of years. I have a year(2018) in one cell and I need to add the number in another cell (5) to that year to show 2023 in the third cell. My dilemma seams to be with that number 5. In excel I got that number 5 with a VLOOKUP Formula so I am not sure if the Date formula is able to read that cell as "5" or if it's trying to read the formula. The Date formula keeps coming back with odd years. Any suggestions?
Hi Excel Campus, I tried to achieve 12 dates from descending coulombs the best I could come up is still the same date? Any idea what else I can do or can someone team view and fix the problem?
My dates are suposed to be 1-3-2019 then under neath 1-4-2019 then under that cell 1-5-2019 I tried series and flash fill and plus nothing is working
HELLO SIR, COULD YOU HELP ME PLEASE? I WANT THE DATE CHANGE EVERY DAY FOR EXAMPLE: I PUT 01-JAN-2020 THEN NEXT DAY WHEN I OPEN THE EXCEL FILE THE DATE MUST BE CHANGE TO 02-JAN-2020 OR AFTER 5 DAYS I OPEN IT THE DATE MUST BE CHANGE TO 06-JAN-2020
THANK YOU SIR.
How can you use that vba, but add 1 month to the Date?
I dont know what the commands are
Good video, but can I ask a question? In my work we have Service Levels. So when request comes in, we have 28 days to deal with it. So say if I’m expecting a request from Joe Bloggs, when I enter into B2 Cell =SUM(A1+28) it brings up 28 Jan 1900 cause I have no information in A1 yet. How do I make that B2 is Blank until I put the request date into A1
Try iferror function
Hi folks anyone know what tool was used to create this tutorial?
How to add a date to bulk records?
how would I make a formula same as this, but I will assign also another cell not only the cell that I had to put the dates, but it will depend on 2 cells. Like if I assign A1 as the date a person should start a day for his quarantine, then the second cell will automatically, let say A2 will appear his 7day of quarantine as HARD QUARANTINE. And the formula for A2 will be =A1+7. Then for the 3rd cell this will assign for his 8th day to 14th day quarantine as SOFT QUARANTINE. The formula. will. appear as =A1+14 for cell A3. but what if the persons are quarantined has different quarantine days. Example, ASIAN people need TO be quarantine for 14 days for HARD QUARANTINE and European people only needs 10 days for HARD QUARANTINE. My question now is how can I assign different formula for ASIAN and EUROPEAN when entering a certain date for a ASIAN people then automatically produce a formula for ASIAN only as well a formula also if the person is EUROPEAN.
Thanks for the video. How can I add 20 working days to a date and not include weekends or holidays?
Great question Marc! We can use the WORKDAY function for this. The WORKDAY function has 3 arguments that allow us to specify the Start Date, Number of Days to Add, and Holidays. The Holidays argument is optional and is typically stored as a list of dates in cells.
If cell A2 contains today's date (12/27/2017), then the following formula would return 20 workdays from today with a result of 1/24/2018.
=WORKDAY(A2,20)
We can also use the NETWORKDAYS function to calculate the number of workdays between two dates.
I will do a followup video on these functions. They are great ones to know. Thanks again and have a Happy New Year! :-)
You can use formula “ Networkdays.INTL”.
For any query you can visit our website www.nurturetechacademy.in
I want formula or solutions for auto fill renew date/ valid upto in front of start date eg. 20/04/2018, 3/8/2020 , 25/7/2014 it becomes 19/04/2020, 2/8/2021 & 24/7/2020 year must be current year but if start date is current year then it will be next year
how to add six months
AWESOME video! Would you ever consider partnering with a marketer to improve your channel/business? I think you have some real opportunities here
Seems like a very flawed method of dealing with dates. How would you add a month to this? I'm just looking for a way to increase a value of dates (due dates for bills) without having to type them in manually every month and it doesn't really seem to be possible from everything I've seen so far without making some big convoluted mess out of things. It should be as simple as selecting the dates and clicking a button and telling it to add 1 month to the date.
I guess this is too much to ask from a company that thinks the Ribbon bar is a good idea. I don't really care if it's there, but removing the drop down menus that made 99% of the things you need to do much easier than the ribbon bar was just idiotic.
This addition formula doesn't work.
Does anyone here know why adding a number to a date doesn’t work in Excel? i.e, A2(01/19/2021)+14=#VALUE
The formula might be wrong.... Actually do u want to add up the 'day' , or the 'month', or the 'year' ?
I have to comment because i spent a good hour trying to figure it out and reading all the text in the formula bars option. Such BS when you realize how simplistic the solution to a problem is.
It's kind of ridiculous for such mature software to not have functions to convert or scale basic values according to their type. It really should be possible to use =A2+DAYS(14) the fact is you have know that date values are days since 1900, is just poor design. Thanks for explaining
No help!!!!