SPREADSHEETS - 06.07.2022

Using WORKDAY to find a particular day of the month

There may be times when you need to find a particular weekday of the month in Excel, for example if you have a journal that needs to be posted on the last Friday of every month. How can you use the WORKDAY function to find this?

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed bibendum, sapien nec interdum commodo, ex elit feugiat velit, vel tincidunt nibh massa nec turpis. Phasellus rutrum pulvinar tristique. Aenean vel maximus velit. Integer in purus dictum, commodo diam sed, facilisis metus. Duis sed consequat nisi. Phasellus et risus neque. Curabitur mattis, nibh ac finibus bibendum, nulla augue commodo ipsum, vitae tristique urna felis in velit. Cras et eleifend lorem, in convallis leo. Fusce id nibh et leo congue convallis. Vivamus imperdiet ipsum sit amet felis condimentum, a lobortis felis rutrum. Integer ullamcorper, turpis in aliquet tincidunt, est tellus volutpat leo, id pretium massa nibh sed orci. Pellentesque ac viverra lacus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Ut ut ante eget nulla volutpat tempor. Donec commodo leo mi, congue blandit leo euismod ut.