Daily report

[christopherp1973]

Hi excel expert

I have daily report which I need to publish daily basis. However, it has been cumbersome for me to change the date of the report. Is there any way to automate it. Here is how it is now.

1) The report will be only publish from Monday to Friday.
2) On monday itself, I will publish the result as on last Friday.
3) Current formula, it was set that =today()-3 if I am working on Mon itself, then subsequent days [ eg Tue, Wed, Thur and Fri , I will have to change to =today()-1.
4) I have to considered the holidays which I have a separate set of table as well.

 

[Saba Sabaratnam]

You could use the following formula

=WORKDAY.INTL(TODAY(),-1,1)

You can add list of holidays in the fourth argument (after 1)

Kind regards

Saba