I have a workbook that charts data for various dates.
I want the chart (called "Chart 6") to display different ranges of data as the years go on.
When I select my chart and go to Select Data, then the Select Data Source window pops up.
Currently, the chart is displaying data from the...
I have found a great macro which allows you to check for the existence of folders in a file-path matching: Year, Month and Day (i.e., creating the folder if it doesn't exist).
For instance, if the FilePath starts: C:\Temp Time Sheets\
it checks for
C:\Temp Time Sheets\2019\
Hi there, I need a VBA to be used in Excel to check a couple of columns (F:F, H:H, N:N) to see if any cell in those columns contain a date that is greater than today and pop up a message. Could you please help?
i need to know what is the toal of monthly payments i have made
i have forgotten how to include a spreadsheet on this forum post!
<colgroup><col style="mso-width-source:userset;mso-width-alt:2560;width:68pt" width="90"> <col...
I would greatly appreciate any suggestions to help solve the problem listed below which uses the table shown below:
FIRST DUE DATE
NEXT DUE DATE
Hi there. I have searched for the answer but I think maybe I'm not quite describing my aim correctly in order for the search to return what I need.
Anyway I'm sure it's pretty easy for you guys. Here goes.
I would like a function/formula for the following.
If cell A1 is greater than the value...
I discovered something today which scared me. Yesterday I had a PersonalXLSB workbook with a number of macros stored. Today, I saw a Personal(AutoRecovered)XLSB workbook with the same macros but named with the Personal(AutoRecovered).xlsb!macro name. I do not know how this happened...
I've been trying to create a formula with multiple criteria, and I can't do it. If there is any number in column C, then I need to look at the dates in two columns (J and AB). If either J or AB has a date more than 28 days ago (based on today), I need it to count how many students have no call...
I am trying to calculate the amount of time from a date (m/d/yyyy) to show # years, # month, # day but ignore cell if blank. The formula I am using is IF([@[BEGIN DATE-MIN ]]<>"",DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y")&" year...
how can I add a year today total at the end of list each of the box in the code below represent amount per moth (January-December)
here is the code:
COGSform_All.TextBox_Results1.Value = .Cells(.Range(strAddress).Row, 2).Value COGSform_All.TextBox_Results2.Value =...
Randomly my excel has changed CTRL + ; from todays date to ...
When i go into options there is no option for keyboard shortcuts. Has anyone any ideas how to revert this back? Checked a colleagues version and only difference I have is having fuzzy lookup installed.
Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD.
So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year.
This is my MTD formula:
Conditional formatting does not apply to dates less than TODAY(), only greater than TODAY().
I have an IF statement with two VLOOKUPS inside. One of them outputs "Not Registered" if the cell looked is empty. The other, just copy the data that is on the other spreadsheet.
Can I have some help please on this
I want to include in the formula below
[IF TODAY() > TODAY () Leave blank
[Range("C23:P34").FormulaR1C1 = "=SUMIFS(Sales!C9,Sales!C5,R21C,Sales!C16,R22C,Sales!C21,R4C3,Sales!C24,RC2)"
Is this possible please
I have excel file data.xlsm and share to another one in my company
Now i want another one can only open file if today < 30/08/2019 (day format as dd/mm/yyyyy)
If Today > 30/8/2019 will have notice: "File has expiry date"
Please help me to do this by macro VBA.
I am new to Excel so apologies if my question will miss pieces of information or is not clear.
We work within the Construction Industry and make monthly projections of our turnover based on prospect.
We assume based on the size of the fee - which is related to the size of...
Hi - I have a spreadsheet with data in columns A:E. In column B is a date. I would like to remove all rows with a date more than 7days older the today(). Ideally i'd like to have a popup that asks remove dates prior to? thanks!
I was looking for a formula to calculate Months and Days Until Next Birthday.
I found this thread
It works well, unless the birthday month and day are the same as today.
In that case (e.g. birthday...