This is what I need in English where B1 is today's date and A1 is a date before today. Basically we cannot service a property until at least 2 months have passed since we did the last service.
If B1 is 2 months or more past A1, then type "Ready" in green in C1.
If B1 is less than 2 months past A1, then type "No" in red in C1.
I cannot figure out the 2 months part bc someone thought it would be a spectacular idea to have months with varying numbers of days in them. Thank you Pope Greg.
Thanks.
Bookmarks