mercredi 2 décembre 2015

Finding less than between months/string

I'm needing to find the difference between two months in excel. One month is listed as a string, the other I'm calculating by doing

=TEXT(NOW(),"mmmmmmmmmmmm")

I've attempted to get values that I could then use to display a Yes/No based on it being less than. Here is what I've tried, they are on individual lines.

=DATEDIF(M9,G19,"YM")
=IF(M9>G19,Yes,No)

The DATEDIF, I was looking to find number of days, then wrap it in an IF and showing Yes/No depending on positive/negative numbers.

Aucun commentaire:

Enregistrer un commentaire