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

Datanology