Using the Excel Today Function to Set Target Dates

Thank you for this.

I would like to ask you a bit of a complicated excel question

You can alse add the "$" in front of the "A" and "1" in the formula so you don't have to write the dates multiple times on Sheet 1.

Hello! I've encountered a delay in the date that today() returns. I think it has something to do with the timezone but I don't know how to correct it. For example, I use it today. I live in PH so it must return Oct 21. But it returns Oct 20. How do you I troubleshoot this?

Hi! Thank you for this. Could I please ask for your help with an issue. I am using an excel template for any given calendar month of any given year. I now have 12 tabs at the bottom, one for each month. But... I am staring in October, and everything is wonderfully automated (drop down when I choose the moth, it changes all the cells for the numbers of the days and for Mon, Tue, etc automatically)... But the rest of the tabs are meant for next year and when I try and change the year, I don't get a drop down to choose from, I get this formula =YEAR(TODAY()) How can I turn that into 2023? Thank you for any help you can provide.

thanks man this tutorial was fairly helpful

Thank you very much

when i tried excel shows this formula is missing range reference or a defined name, what to do

Bless you! Thank you so very much!

Applied the same formula and trick..but it's not showing the numbee of days instead showing the entire format month day date

if i put =today() or =now() formula in a cell today, if i open the spreadsheet tomorrow i want yesterday's date to be displayed in that cell

I can't find Ribbon from Preferences, view. How can't customise the ribbon. Anybody knows how to customise when I can't find ribbon on preferences menu?
Thank you

Please explain how to stop the Today formula
for example i have two dates 22/08/2020 and target dates 19/09/2020
So the today formula is calculating the over days
i want to stopped it on balance day zero

Could you please make a video on it or here in comments can explain

no need to ask if we found the video helpful everytime because the answer is always YES!

Sir, how to make today - 1 day = yesterday (in dd/mm/yyyy)?

Amazing! Please make more videos using time/date functions if you can. These are so helpful!

Summarize : Need two sheets : write down your expecting days on one sheet. Then open another one use the function : TODAY()

The 3 C's. Clear, Complete and Concise. What a great Teacher.

I didn't know such a thing existed on Excel. Thank you!

Im a microsoft office tutor at my local technical college so video like this help me stay updated with information especially these functions, Thank you

Great tip. Question? Does Excel recognize leap years? Thanks for all you do. Jim.

Thank u, nice day to you ))

That's very helpful video about today. And what is the function for automatic count of the days that are recorded in the above? Will the number of days change with the next date?

God bless you.this helps so much

When I tried this operation for the first example, the answer came out as another date. 1/17/1900. I then formatted the cell that the answer appeared in as general and the answer appeared in the proper format; as a number.

Good knowledge

Really so help video. Thank you for sharing 👍👍

You always make great tutorials, thx : )

Any video on checkifs maxifs etc.

Very well explained. Need more of these videos on formulas

So useful! Thank you for sharing this!!!

Extremely useful! 👋🏾👋🏾👋🏾
Thank you for sharing.

Great trick it will safe a lot of time

very helpful. I love these short lesson.