#date

I am trying to take a date in A1 add 30 days to it or if there is no date leave blank.

Hello, I am trying to track some testing specimens at work, and I would like to have to automatically populate a date when the status drop down menu is changed. For example, I have a status column located in column G. The status has a drop down menu including Not Received, Specimens Received...

Have a network data sheet that has loads of projects and dates. I update this sheet daily on my local machine, but I can't track changes. I would like to copy this entire sheet to dedicated Monday-Friday sheets in the same workbook depending on what TODAY is. (If today is Monday, copy the sheet...

Hi excel community, It’s finally the point in my life where I realised how powerful but painful excel can be and would like to learn more. As the attached table, I have a simple pivot table stating the names on the first column, and the dates of testing of the second column. For some names...

I'm being given the format "mmm-dd-yyyy" (for ex: Jul-02-2019), however excel doesn’t interpret this text as a date value. I'd like to convert it a date value and format it as "dd/mm/yyyy" (ex: 02/07/2019); thoughts?

PLEAAAASSEEE HELP ME!!! I am trying to create a route from an excel sheet where it will be placed to a site program then it will auto generate depending on the data provided. I have used basic excel methods but to no success. I need to have the properties scheduled on a monthly basis depending...

I struggle with CountIf functions. I know this should be pretty straight forward, but I can't wrap my mind around it. Below is how the spreadsheet is set up. Don't worry about the conditional formatting of the cells or colors of the dates below. Just for visual. But I want each cell to auto...

Hello everyone, I have a question regarding TODAY() function in Powerpivot or maybe general in excel. My model and most of calculated formulas depend on function TODAY() as I have historic data with column SOURCE DATE and ewhen i am updating every day the values are calculated from the data of...