VBA Reminder 2 working days before last working day of the month

[trev24]

Hi everyone!

I am currently having a hard time finding the code that would remind me 2 working days before the first working day of the month. I am using Excel 2010. Any help is very much appreciated! Thank you!

 

[Chris Mack]

This formula is working for me; it just gives either a "Y" or "N" as to whether or not today is two working days before the first working day of the next month.

=IF(WORKDAY(WORKDAY(EDATE(DATE(YEAR(TODAY()),MONTH(TODAY()),1),1)-1,1),-2)=TODAY(),"Y","N")

For VBA I guess you could use "Evaluate"?

Hope this helps,

Chris.

 

[pavithran]

please help me

in excel 2016 how to do excel date reminder in sheet1 automatic find before 30 days including month year .

For example ,
Today 01/07/2016 end date 30/08/2016 reminder 01/07/2016 until change the date.

please help me
pavi