Excel Desktop
338 Topicspre-1900 dates
I can find no help on how to tell Excel to properly format and calculate dates before 1900. I want to calculate age at death and have birth and death dates in columns. But Excel does not recognize March 30, 1894. It calls is YYYY = 3794. And subtracting death date from birth date returns "#VALUE!" How do I use the DATE(YYYY,MM,DD) function or format March 30, 1894 so Excel will understand and I can have it calculate the age at death correctly? TIA. Also I've seen #1 shown in Excel Help in different posts as BOTH Dec 31, 1899 AND as Jan 1, 1900. Which is it?62KViews0likes15CommentsChange month only in a column containing several rows of dates
Apologize if this has been solved previously. I am attempting to change the month only in a column of already entered dates in a column. For example I have 1/2/2018, 1/5/2018, 1/17/2018, 1/20/18 etc. and want to only change the month from Jan to Feb like this: 2/2/18, 2/5/2018 etc. Any ideas?Solved57KViews0likes14CommentsCan you use AND / OR in an INDEX MATCH
Hi I have am array formula that looks like this: =INDEX('Rebate report'!A:A,MATCH(1,('Rebate report'!A:A=A2)*('Rebate report'!B:B=B2)*('Rebate report'!C:C=C2),0),1) which works. I want to add in an OR function for the name in column A. I will add this name in Column T. In other words the match is correct if column A or T match A2 and COL B=B2 and COL C=C2 also match the criteria I tried using the + to add T criteria but gave me a 0 =INDEX('Rebate report'!A:A,MATCH(1,('Rebate report'!A:A=A2)*('Rebate report'!B:B=B2)*('Rebate report'!C:C=C2)+('Rebate report'!A:A=T2),0),1) Thanks for the help!135KViews0likes61CommentsExcel Autosave
I Have Office 365 installed in Windows 10 PC. The Excel Version is 1708 Build 8431.2107. I am not able to see the Auto Save icon on the top left corner. I have tried to open the file from One drive but still that Icon is missing. How do I get the Auto save option.3.1KViews1like6CommentsPivot table won't refresh.
I'm getting an error when I try to refresh PivotTable data - and it's not updating a field I've made changes to. The error message is: "The pivot table field name is not valid. To create a valid PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name of the field." Thing is, I am using tables with labeled columns, I've tried renaming the pivot table, the fields, everything I can think of. Nothing works. So I end up re-creating the PivotTable over and over, but it still isn't refreshing the data. Help!23KViews0likes6CommentsIssues with Pivot table: Data Model is not applying relationship
Hi there, What I'm trying to do is build a pivot table that utilizes a data model. Unfortunately, for some reason, the relationships described in the data model are not being applied to the pivot table. I'm not sure what I'm doing wrong. The table structure is very simple. My Tables: Data Relationship Pivot Table My Expected Results are: James Corbin: BA Jim Jam: PM Lara Croft: Java, BA, PM Row Low: Java, .NET What am I doing wrong? Thanks in advance.25KViews1like9Comments