Quickly Enter Current Date and Time in Excel

Is there a quick key for yesterdays date? I know cntl+: for today but i want a quick one for the day before

Nice nice

Great trick, thanks!😁

So how can i set a sequence of dates for only mondays tuesdays and thursdays?

hello if i want to add particular date properly in table listed..how to do it properly?

ctrl shift ;
for time
=today
for date

On Google sheets, you double click and a calendar pops up. Why can't I do that?

🤩thanks

calender

Ctrl + shift + ; not working in excel for me. It worked two days ago. Any help would be appreciated.

how to auto fill the month and year to current month and year, example i will type "8" then automatically it will put date aug 8, 2022 and not jan 8 1900?

Thank you for the tip. By the way, , 11/30/?? Is my birthdate.

thank you so much sir . take love

Hello! Good video! Do you know what is the shortcut for the NOW function? In other words, how can I add quickly the NOW function without it changes over time? Thank you! Have a good one. Silvina

not working for me on excel 2021. edit: u need to use shift also.

Tnx

Short and sweet, thank you! One quick question, I use Excel to track phone calls and the date I make the call. If I make many calls on the same day, I can't just click on the lower right-hand corner of the previous cell (drag it down) and have that date copied into the cell below it; I get the date of the following day. How can I replicate the date?

Thx

yes it's very informative. Thank you!

Awesome sir thanks a lot💙