I created a formula that calculates the Start Date and todays date, the formula's goal was to calculate the amount of days from the start date. This formula appeared to be working fine until recently when I checked the stat and is displayed 01 as the number of days.
F4 is the cell that contains the start date and time 9/10/04 8:00 AM
The Cell format was 'dd', I also tried 'mm dd' and 'yy mm dd'
When I added 'mm' to the cell the month was displayed as 02 which is also incorrect.
Thanks in advance for any help, I'll try to attach a sample of the formula.