Forum Discussion
Trying to Calculate the number of Days Since a past date.
I'm calculating the number days since my calves birthday to help in a future project. I've used the DAYS360 formula. For example, I have a calf that was born on 7/12/23. I use the formula typed like this =DAYS360(C2,TODAY(),FALSE), which gives me the answer 1/19/00. But I want the answer to say 19 instead. How do I accomplish this?
This is also on a Mac.
- first off I don't think you want days360 as it is based on 12 months of 30 days each (i.e. 360 days in a year instead of 365). As to what you want is simply =TODAY()-C2
As to the format 1/19/00 you just want to change the cell number format to NUMBER and you can change the number of decimal places to 0 - Change the number format to General.
