First of September of current year only

[sdjames1979]

Hi All

I need the criteria to show dates on 1st September of the current year only.

Today, it should show 1st September 2015, this time next year 1st September 2016.

Thanks

S

 

[Minty]

This will give you the first day of the current month, I think that is what you are after?
=Date()-(Day(Date())-1)

 

[sdjames1979]

Hi, thanks for that.

However, the first day of the current month is not what i'm looking for, I need a specific day/month but of the current year only.

In five years time, it should bring up 1st September 2020, whether i run the report in January or December 2020.

Thanks

 

[Minty]

If it is always the first of September of the current year, you need simply

=Format("01/09/" & DatePart("yyyy",Date()),"Long Date")

 

[deanamiles86]

Try This

"1st September" & Year(Date())

 

[sdjames1979]

YOU ARE A STAR!

I love you. x

 

[sdjames1979]

(sorry) lol