Thank you! Solved what I wanted to do for dates occurring within one week of Today()! ;)
@triciapena90802 жыл бұрын
I have looked all over for exactly this video, Thank you!!!!! A little quick but precise.
@trishabojan2 ай бұрын
Thank you - you have presented in a way that I can understand.
@mattwoodward72663 ай бұрын
Thank you! That Today() function is really powerful
@cailinanne3 жыл бұрын
Ugh. It took me like 30 minutes to teach this to myself! haha, wish I had found you sooner!
@rodneygarrard1 Жыл бұрын
very good introduction for me. I have been mucking around with the today function without much success, Thanks
@officecoordinator62432 ай бұрын
Thank you so much! Great Job!
@Robinhooood13 ай бұрын
Thankyou, this saved me hours!!
@rickja1 Жыл бұрын
This was very helpful. Thaks for taking the time to share!
@ghostcon3 ай бұрын
Exactly what i needed thank you!
@JSTX92168 ай бұрын
This worked for what I needed!
@michaelyong7722 жыл бұрын
Excellent. Very helpful. Thanks
@DefinitiveRulez Жыл бұрын
Great Video, Thanks
@user-hv4fl6zh3n Жыл бұрын
Thank you! So simple~
@whyworksmarternotharder Жыл бұрын
Glad it helped!
@jaredgreenlee466411 ай бұрын
Super helpful. Thank you
@ladiascc1934 Жыл бұрын
Very good, thank you.
@loriholman9071 Жыл бұрын
Quick and good information.
@whyworksmarternotharder Жыл бұрын
Thank you!
@jaskaran43 Жыл бұрын
Very well explained. Great Job!
@whyworksmarternotharder Жыл бұрын
Thank you
@ahmedhassen65959 ай бұрын
perfect
@carlosvazquez87112 жыл бұрын
This is great stuff, thank you!
@michaelhoult98 ай бұрын
great video
@scottheddens72773 жыл бұрын
Great Vid.
@maraeuteneuer77893 жыл бұрын
Great work!
@bonkersben139 ай бұрын
Thank you! Can I add I new column to tick off any completed dates, removing the red highlight?
@alisonkelly38382 жыл бұрын
amazing thanks
@Hynessiiee526 ай бұрын
Hey, I have 2 colums. Colum C is the date of the test i did. Colum D is the due date in 3 months time. How do i create rules so within from day test was done to 1 month away from due date the colum is green. 1 month to 1 day before due date it is yellow then the date the new test is due and beyond it is red? Colum D is set up as =EDATE(C2,3) So I only ever need to input the new date i've done a test.
@aamirsohail4784 Жыл бұрын
Great vid😊
@deborahmitchell9663 жыл бұрын
Great tutorial
@whyworksmarternotharder3 жыл бұрын
Thank you!
@omni16912 жыл бұрын
i did learn some thing - LIKE!
@whyworksmarternotharder2 жыл бұрын
Boom!
@mariam4084 Жыл бұрын
Great
@andreweuteneuer38613 жыл бұрын
Good job!
@whyworksmarternotharder3 жыл бұрын
Thank you!!
@whyworksmarternotharder3 жыл бұрын
Appreciate your comment
@oanhluong70513 жыл бұрын
Hi! I need help with creating student employee estimation budget spreadsheet. I am not so sure how to create it because formula involved. Andrew can you help me? Thanks
@mizcanbro3 жыл бұрын
Nice job!
@whyworksmarternotharder3 жыл бұрын
Thanks for the comment and kind words!
@stosgarage4562 жыл бұрын
Thanks
@mohanpal135553 жыл бұрын
Great work
@whyworksmarternotharder3 жыл бұрын
Thanks for the kind words and the comment!
@dheerajjoshi38692 жыл бұрын
nice video
@TonyNRoca2 жыл бұрын
Definitely smarter
@dlkhills Жыл бұрын
Nice
@desleybettens5356Ай бұрын
Can you nest these functions?
@nitinjangda3159 Жыл бұрын
if the due dates is not a fixed date for all the rows, then ? if every case number had a different due date in column C then what would be the formula ?
@ryanculverwell3 жыл бұрын
thanks
@whyworksmarternotharder3 жыл бұрын
Thank you for watching!
@btentertainment17006 ай бұрын
How to highlight a cell after 5 days which contains a date. Cell should highlight after 5 days from the date in the cell.
@duncanlingrueyshan7199 Жыл бұрын
Hi, may i ask how to set the weekends to count saturday on the weekends ? because my company work on sat on the first and third week
@lockemdownrecords Жыл бұрын
Question. So if I put today's date in 1-6-2023 will the sheet automatically turn that text red on 1-11-2023 because it's been five days?
@mariafebusgano88702 жыл бұрын
is it applicable to google sheets too?
@gatitamayorga Жыл бұрын
Can you tell me how I can get reminders from excel to my outlook ?
@whyworksmarternotharder Жыл бұрын
That’s a good video idea
@ultraniusmaximus15363 жыл бұрын
Thanks for this video! Ok, so more questions for you... I'm familiar with the today() function by adding or subtracting days from today, but what I'd like to know is how to show expiring dates in the future (e.g. 3 months, 2 years and so on)? Also, how would I apply that to multiple, non-consecutive columns in a worksheet? I've tried using absolute, such as $B$4, but when I go to apply that to multiple columns like I described above, it keeps using that cell's specific date and not the date of the other cells I want it to effect. And last question (promise!): is there a way to have some kind of notification such as a pop-up window when a certain date has expired, or is expiring very soon (aside from just colors)?
@whyworksmarternotharder3 жыл бұрын
I don’t believe there is a way other than through VBA he would be able to create a pop up. You can however use conditional formatting based on the values in another cell. I have a video on that as well. Not 100% sure I understand your question.
@ultraniusmaximus15363 жыл бұрын
@@whyworksmarternotharder Hi. I guess I was making the question more confusing than it needed to be, sorry. The closest formula I could find that I 'think' I was using is the following: =AND($B2>=TODAY()+60, $B2
@OfficeFreak3 жыл бұрын
@@ultraniusmaximus1536 Please check this Video. I think this Video may be helpful to you. Video is in Hindi language but it has English Subtitles
@ultraniusmaximus15363 жыл бұрын
@@OfficeFreak Could you post the link, please? I will check it out. Thank you.