Calculate number of months automatically till Today

How can calculate number of months automatically till Today

Actually I want to create a monthly fee dues in the last column.

Use Datedif formula

=Datedif(date,now(),"m")

If u want to Cal years out y instead of m

If u want to Cal days then put d

Number of month from when ?

if within same year....

.

=MONTH(TODAY())-MONTH(CELL.REF)

.

add +1 if want to count with current month....

.

=MONTH(TODAY())-MONTH(CELL.REF)+1

If you have any query or want any help related to excel feel free to join our Telegram channel and message us..

Channel link :

https://t.me/msexcelmaster101