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!!
