Getting the First day of the month in VBA

This code should be added within a module to assign the first day of the month to the variable: fst_crnt_mnth

act_dte = Now() - Day(Now()) + 1 'Gives you the first day of the current month

Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us