admin
440 TopicsConditional format 30-60-90 days to 1year old
I am trying to automatically highlight a date when it is 30-60-90 days from its due date but I want to use the date a certificate was issued. Example: I have a cert that was issued on 5-26-2021 and expires 1 year from that date. In the photo, I want that cell to highlight when today is less than 30-60-90 days from 26-may-2022. I want to keep the issued date in the cell but I want it to highlight when it is 30-60-90 days from its 1 year expiry date(without having to add expiry date. I don't want more info than needed.)Solved66KViews0likes16CommentsEXCEL LOGO
Hello everyone, I have a question. Office programs' logos always start with their first letter. Example: Like Word-W. However, Excel's logo is a combination of the letters X and L. I would like information about the creation process of logos. Can anyone with knowledge help? Kind regards.49KViews0likes4Comments2013 doesn't have =filter() function. ANY alternate function?
I have Microsoft excel 365 in that filter function is available and i create a follow up sheet linked with database sheet where in database user will store data from the form. In database there is a column Follow up date. I want to show the all the data which will meet a date condition. I have done by using filter function but in 2013 it doesn't have filter function what function can i use to perform the same operation?23KViews0likes3CommentsFormula for adding time
How to make an addition of time in Excel minutes and hours I believe hours are easy because you just need to sum all the numbers but how about minutes I want to track my time if I have already 8 hours of work per day. I want to input the task then Excel will compute the minute 🙂 so is there a specific formula for this?Solved21KViews0likes4CommentsA connection was successfully established with the server, but then an error occurred during the pre
@Sergei Baklan I'm trying to use parameters in power query. I am now having a new error appear: DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Details: DataSourceKind=SQL DataSourcePath= (some server name) Message=A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ErrorCode=-2146232060 Number=10054 Class=20 I'm connecting to a Linux server, OS: 3.16.0-4-amd64. Typically, when connecting to it I go to get Data -> Odbc -> and then select the DSN and paste my SQL statement in the advanced options ... and it works perfectly Now I'm trying to use the following M code and it is giving me the error shown above Source = Sql.Database(Server, Database,.....) Thank you for the help19KViews0likes1Comment