today

Hi everyone. I have been searching and searching, but could not find anything. I am using a form in Excel and in the date filed, I have a "pop up calendar." I created the form in April 2018. When I click the field, the calendar pops up. At the bottom, it says Today: 7/16/2018 like it...

I'm trying to figure a formula that changes the date based of the month. I.e. I'm Using the today formula and need specific column to be the 25th of each month. So today is the 11th and the event is happening on the 25th. can I have a formula that changes as today changes.

HI IVE USED THIS THAT SOMEBODY BUILT FOR ME FOR A WHILE... I CHANGED A FEW THINGS TODAY NOW WHEN I TRY AND SEND IT GET THIS ERROR

Hello there, I'm creating a file in which due dates are monitored. I would like the cell to be green if the due date is >1 month from today, orange if <1month from today, red if past due date. I've attached a sample file. How would I go about doing this? Thanks for any help!

Hi, Totally new to using VBA but really need a script to be able to do the following: I have a sheet named "Calendar" that has a row for each day of the year in order to plan and prepare social media posts for specific days. I have a second sheet named "Archive" where I would like the already...

I have a spreadsheet that tracks some things. Column A holds a date, Column B holds a #; And Column C holds a $ amount. I want to change the font of Column C to red if Column A plus Column B is Greater than today. So for example; <tbody> A B C 6/10 10 $100 6/1 10...

Good day, thanks for reading and try to help, I have recorded this macro and the only thing that I did here to unselect all dates on slicer and then select today's date I want to see how can I configure the same code for only selecting today's date only and also this list will grow more...

Good day I will like to ask if someone can help me to create a code for a button that will filter a pivot table for "today's date" and only the information that is due for today is this possible or too difficult thanks

Hi guys so I have a formula that needs to show 3 things as of today if Date is within a year ( of today) = Ok Date is within 30 days ( of today) = >30 daysDate has passed ( as of today) = Expired This is what I have and cant seem to get >30 days to...

I have F2 returning True and False depending whatever conditions are met, and I want a pop up to appear asking user to enter date that will appear in G2. I want to make a VBA script that does the following: If F2 is TRUE, then a Pop Up appears prompting user to input a date in format...

Hi there! Might be a rather simple question - but has been causing me a TON of trouble... I have a report that is published every weekday - it usually needs to capture the previous BUSINESS DAY, but on MONDAY, needs to reflect the previous FRIDAY (or, business day...). Seems pretty simple...

Hello guys, How do I go about setting a cell to show a date 3 workdays from today? =DATE(WORKDAY(TODAY,3)) or something?

Morning all, I have the following calculation in my sheet :- =IF(AT154="","",MAX(AT154:CI154)) if there is a date in present in AT154 then this formula will look along that row and in cell AJ154 will return the value of the most recent date in that row. However we have now started to...

I'm not sure why this formula isn't working. If AZ2 = "", then I want to return the value of 0. If it isn't null, I want to get the number of days between Today and the max date in column AZ. =IF(AZ2="",0,TODAY()-(MAX(Financials!AZ:AZ))) When I enter the formula on the Financials sheet, it...

In my listbox I would like to change the colors of the lines according to the dates, for example if the date of the cell is equal to the date of today then the whole line should have the color green please help:(:(:(:( ...

Hi Need some help here I want to be able to find the sum of November 1 to the current day of the month (will automatically update based on what day it is today) For example if today is 11 I want it to calculate the sum of the first 11 cells in column b which should return the value...

Using MS Excel 2013. Need help with a formula detailing the number of years, months, and days that have passed based on TODAY. A1 = 2016/08/15 B1 = ? Any assistance will be greatly appreciated it!