BloggerAce
New Member
- Joined
- Jul 28, 2015
- Messages
- 9
I am sure I am overthinking this formula but I am needing to setup a spreadsheet to be able to calculate two dates (one static date (doesn't change) and the other is today's date (changes daily).
One cell contains a EOL date and the other is today's date using (=today() formula).
When I place a formula in the next cell - DATEDIF(A1,B1,'M") it returns a #NUM! error. I believe it is because the Today's date is a formulated response.
How can I get this accomplished?
Thank you in advanced.
AceBlogger
One cell contains a EOL date and the other is today's date using (=today() formula).
When I place a formula in the next cell - DATEDIF(A1,B1,'M") it returns a #NUM! error. I believe it is because the Today's date is a formulated response.
How can I get this accomplished?
Thank you in advanced.
AceBlogger