aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi All
is there a way to get week number for the month along with month name in excel using the formula
For Ex if Column A has date 30/Jan/2022 then in column B I need this date to appear in format "Jan week 5"
and if the date is 2/Feb/2022 then it should update as "Feb week 1"
is there a way to get week number for the month along with month name in excel using the formula
For Ex if Column A has date 30/Jan/2022 then in column B I need this date to appear in format "Jan week 5"
and if the date is 2/Feb/2022 then it should update as "Feb week 1"