Hi,
I have developed an excel data sheet to extract data every day. For example on sheet B01 in cell H4 I have written the formula "=COUNTIF(H13:H100007,"=04/07/2018")". This is to extract no of days that equal to 04/07/2018. At the moment I am manually changing this date. For example if I need to extract date for today I manually change the date for every sheet as "=COUNTIF(H13:H100007,"=06/07/2018")".
Is there any method that I can change this formula automatically to todays date? I greatly appreciate any help
Bookmarks