How do i get the last business day of current month

[bhanupriya.cb]

Hi Team,

I need to get the last working business days of current month excluding weekends as below, also please help me to write the same thing in excel

Feb - 28-Feb-2023
March - 31-mar-2023
April - 28-mar-2023

Please help me to achive this

[bhanupriya.cb]

Thanks for your reply, but y i am getting as below? Month is not visible

[bhanupriya.cb]

Hi

=WORKDAY(EOMONTH(TODAY(),0),-1) this formula is giving an answer as 02/27/2023 but in Feb month the last working day is 28 Feb 2023

[nikhil.girish]

Hi @bhanupriya.cb

Check this out

Calculate last business day of each month

@Aguirre - You can use below code get last day of the previous month…and then check if its Sat or Sunday… If Sat then -1 day to get 07/30, if its sunday then do -2 get the last business day… [image] Hope this helps…

Hope this helps thanks

[Anil_G (Anil Gorthi)]

@bhanupriya.cb

On excel directly use this formula…and it should give the last working day

=WORKDAY(DATE(2023,2+1,1),-1)

Here 2023 and 2 can be variablized depending on the requirement…this is for feb

If its current month always then

=WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),-1)

Cheers