Copper Contributor

How can I use a formula that allows me to write a number found in a table if today is an especific month?

3 Replies


You may check if TODAY() is in specific month, but what is in your table? Are where dates, months, etc and how they are linked to numbers you'd like to find?

@Sergei Baklan 

Thank you Sergei.
I have a table divided in months in one column and the next column one number per month.
What I need is that in other cell excel gives me the number from the previous table if today is "march" corresponding to that month


Perhaps you mean something like this, not sure