Notifications
Clear all
Topic starter
Hi every one
could you pleas help me how to convert week to month
e.g. Week (21) it come Month(May)
Thanks/Saliha
Posted : 23/05/2018 3:31 am
=MONTH(DATE(YEAR(NOW()),1,1)+21*7-1)
converts 21 weeks to month 5, based on the current year. Change the 21 to a cell reference of the number of weeks as desired.
Posted : 23/05/2018 1:00 pm
Topic starter
Hi Robert
its a fantastic answer and thanks for supported.
Posted : 24/05/2018 12:11 am
