TODAY function not working in Microsoft Excel

0 votes

I want to figure out how many days have passed from the start date. I'm using the function =TODAY()-C3 for that. The start date is located in C3, as seen in the image. Yet, the response will arrive "03-Jan-00." That works if I only type =TODAY() or =TODAY()+5. For your benefit, I have attached a snapshot and a Google Drive link where you may view a screen capture of the issue.

https://drive.google.com/file/d/1lQ7djK1BRICjFfAaAG0T08snuRZhcU-k/view?usp=share_link

enter image description here

Feb 20, 2023 in Others by narikkadan
 • 63,600 points • 1,397 views

1 answer to this question.

0 votes

Works as shown:

enter image description here

Just note that cell c1 is formatted as a number.

answered Feb 20, 2023 by Kithuzzz
 • 38,000 points

Related Questions In Others

0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
 • 63,600 points • 913 views
0 votes
1 answer

Excel SUM function is not working (shows 0), but using Addition (+) works

The values in A1 and A2 are ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
 • 63,600 points • 752 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
 • 63,600 points • 686 views
0 votes
1 answer

Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

Average Every Nth Row All three finish in ...READ MORE

answered Mar 27, 2023 in Others by narikkadan
 • 63,600 points • 404 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 4,146 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 2,017 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
 • 13,690 points • 996 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
 • 23,260 points • 3,730 views
0 votes
1 answer

Excel number formatting thousands is not working

Follow these steps: 1- choose cells you want ...READ MORE

answered Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 12,275 views
0 votes
1 answer

Function to filter excel table data in to a new dataset based on value defined in another table

If you just want to add up ...READ MORE

answered Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 894 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.