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 in Others by narikkadan
 • 59,740 points • 81 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 by Kithuzzz
 • 34,760 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
 • 59,740 points • 178 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 in Others by narikkadan
 • 59,740 points • 92 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 in Others by narikkadan
 • 59,740 points • 72 views
0 votes
0 answers

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

With Excel, I'm attempting to average every ...READ MORE

5 hours ago in Others by Kithuzzz
 • 34,760 points • 4 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,630 points • 270 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,630 points • 530 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,630 points • 260 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
 • 22,970 points • 300 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 in Others by Kithuzzz
 • 34,760 points • 66 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 in Others by Kithuzzz
 • 34,760 points • 67 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.