Belleke Well-Known Member May 16, 2017 #1 I have a cell that returns the current month (VBA) Code: [B30] = Format(Date, "mmmm") In cell [C30] i would like to have the number of months left included this month (8) Please advice, for some reason, I can' figure it out. Thanks
I have a cell that returns the current month (VBA) Code: [B30] = Format(Date, "mmmm") In cell [C30] i would like to have the number of months left included this month (8) Please advice, for some reason, I can' figure it out. Thanks
N NARAYANK991 Excel Ninja May 16, 2017 #2 Hi , Shouldn't this do it ? [C30] = 12 - Month(Date) + 1 Narayan
Belleke Well-Known Member May 16, 2017 #3 Perfect my friend. Thanks and have a nice day. PS: I tryed to give you a like but I don't know if I worked
Perfect my friend. Thanks and have a nice day. PS: I tryed to give you a like but I don't know if I worked
