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