Excel Formula/Date/Number Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-1813036%22%20slang%3D%22en-US%22%3EExcel%20Formula%2FDate%2FNumber%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1813036%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReaching%20out%20here%20to%20see%20if%20you%20can%20help%20me.%20I%20tried%20messaging%20Microsoft%20on%20chat%20and%20even%20called%20them%20this%20morning...%20then%20went%20to%20the%20Apple%20store%20too.%20NO%20ONE%20COULD%20HELP!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recently%20bought%20my%20MacBook%20Air%20in%20July%202020%2C%20and%20right%20after%20bought%20the%20Office%20365%20Home%20version%20for%20my%20computer.%20My%20manager%20uses%20a%20PC%20computer%20and%20in%20one%20of%20our%20accounting%20files%2C%20we%20have%20the%20formula%20%3DTODAY()-B7.%20What%20we%20are%20finding%20out%20is%20number%20of%20days%20where%20invoices%20are%20at%20that%20way%20we%20can%20pay%20suppliers.%20When%20this%20formula%20is%20inputted%2C%20I%20get%20a%20%23VALUE!%20kickback.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20whatever%20reason%2C%20the%20only%20time%20the%20formula%20will%20work%20is%20if%20I%20removed%20the%20-B7%20item%20and%20leave%20it%20as%20%3DTODAY().%20But%20that%20is%20not%20what%20I%20need...%20the%20formula%20they%20have%20been%20using%20for%20years%2C%20and%20it%20still%20works%20for%20others%20on%20their%20PCs%20but%20not%20my%20Mac.%20I%20don't%20know%20if%20there%20is%20a%20setting%20feature%20that%20I%20need%20to%20change%20or%20what...%20I%20tried%20changing%20the%20format%20to%20number%2C%20general%2C%20etc.%20and%20nothing%20works.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20in%20another%20file%2C%20I%20have%20codes%20like%205001-01%2C%205002-02%2C%20etc.%20And%20the%20file%20automatically%20changes%20these%20values%20to%20dates%20for%20me.%20But%20yet%20for%20my%20manager%2C%20her%20end%20is%20fine...%20they%20even%20try%20sending%20me%20their%20files%2C%20and%20it%20doesn't%20pop%20up%20on%20my%20end...%20still%20shows%20either%20%23VALUE!%20or%20a%20date.%20In%20order%20for%20me%20to%20work%20off%20the%20file%2C%20they%20have%20to%20copy%20and%20paste%20the%20number%20values%20for%20me...%20but%20this%20is%20MY%20JOB%20to%20do%2C%20not%20theirs.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%2C%20something%20is%20clearly%20messed%20up!%26nbsp%3BToday%20I%20have%20made%20all%20updates%20and%20even%20uninstalled%20and%20reinstalled%20the%20Office%20365%20program%2C%20and%20it%20still%20won't%20work.%20Any%20support%20here%20would%20be%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1813036%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1813481%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20Formula%2FDate%2FNumber%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1813481%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F843817%22%20target%3D%22_blank%22%3E%40LouieJ%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CFONT%20size%3D%223%22%3ETODAY%20function%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E%3CSPAN%20class%3D%22appliesToItem%20x-hidden-focus%22%3EExcel%20for%20Microsoft%20365%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%20for%20Mac%3C%2FSPAN%3E%20Excel%20for%20the%20%3CSPAN%20class%3D%22appliesToItem%22%3Eweb%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%3C%2FSPAN%3E%20Excel%20%3CSPAN%20class%3D%22appliesToItem%22%3E2016%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%20for%20Mac%3C%2FSPAN%3E%20Excel%20%3CSPAN%20class%3D%22appliesToItem%20x-hidden-focus%22%3E2013%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202010%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202007%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%20for%20Mac%3C%2FSPAN%3E%20Excel%20for%20Mac%20%3CSPAN%20class%3D%22appliesToItem%22%3E2011%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20Starter%202010%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ftoday-function-5eb3078d-a82c-4736-8930-2f51a028fdd9%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20size%3D%223%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ftoday-function-5eb3078d-a82c-4736-8930-2f51a028fdd9%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E%3CSTRONG%3ENOW%20function%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20for%20Microsoft%20365%20for%20Mac%3C%2FSPAN%3E%20Excel%20for%20the%20%3CSPAN%20class%3D%22appliesToItem%22%3Eweb%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%3C%2FSPAN%3E%20Excel%20%3CSPAN%20class%3D%22appliesToItem%22%3E2016%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202019%20for%20Mac%3C%2FSPAN%3E%20Excel%20%3CSPAN%20class%3D%22appliesToItem%20x-hidden-focus%22%3E2013%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202010%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202007%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%202016%20for%20Mac%3C%2FSPAN%3E%20Excel%20for%20Mac%20%3CSPAN%20class%3D%22appliesToItem%22%3E2011%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22appliesToItem%22%3EExcel%20Starter%202010%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22appliesToItem%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fnow-function-3337fd29-145a-4347-b2e6-20c904739c46%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20size%3D%222%22%3E%3CFONT%20size%3D%223%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fnow-function-3337fd29-145a-4347-b2e6-20c904739c46%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20and%20would%20be%20happy%20to%20know%20if%20I%20could%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello community! 

 

Reaching out here to see if you can help me. I tried messaging Microsoft on chat and even called them this morning... then went to the Apple store too. NO ONE COULD HELP! 

 

I recently bought my MacBook Air in July 2020, and right after bought the Office 365 Home version for my computer. My manager uses a PC computer and in one of our accounting files, we have the formula =TODAY()-B7. What we are finding out is number of days where invoices are at that way we can pay suppliers. When this formula is inputted, I get a #VALUE! kickback. 

 

For whatever reason, the only time the formula will work is if I removed the -B7 item and leave it as =TODAY(). But that is not what I need... the formula they have been using for years, and it still works for others on their PCs but not my Mac. I don't know if there is a setting feature that I need to change or what... I tried changing the format to number, general, etc. and nothing works. 

 

Then in another file, I have codes like 5001-01, 5002-02, etc. And the file automatically changes these values to dates for me. But yet for my manager, her end is fine... they even try sending me their files, and it doesn't pop up on my end... still shows either #VALUE! or a date. In order for me to work off the file, they have to copy and paste the number values for me... but this is MY JOB to do, not theirs. 

 

As you can see, something is clearly messed up! Today I have made all updates and even uninstalled and reinstalled the Office 365 program, and it still won't work. Any support here would be greatly appreciated. 

 

Thanks so much!! 

1 Reply
Highlighted

@LouieJ 

 

TODAY function

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Starter 2010

https://support.microsoft.com/en-us/office/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9?ui=en...

 

NOW function

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Starter 2010

https://support.microsoft.com/en-us/office/now-function-3337fd29-145a-4347-b2e6-20c904739c46?ui=en-u...

 

Hope I was able to help you and would be happy to know if I could help you.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.