Assistance on DatedIF formula

[BloggerAce]

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

 

[Fluff]

Sounds like B1 is less than A1

 

[BloggerAce]

Sounds like B1 is less than A1

That is correct. Thank you Fluff.

AceBlogger

 

[Fluff]

You're welcome & thanks for the feedback.