Any November date within the current year

**sdjames1979** · 09-25-2015, 09:24 AM

Hi

I'm looking for a formula that shows ANY November date in the current year, ie.

Today's results should show November 2015 dates.
In five years time, the results should show November 2020 dates.

Thanks in advance.

S

**sweep** · 09-25-2015, 09:35 AM

HI,

=DATE(YEAR(TODAY()),11,1)

Will return November 1st 2015. Does that help?

**sdjames1979** · 09-25-2015, 09:41 AM

Thanks for that, however, I need it to show ANY November dates in the current year, not just November 1st.

In 2015, it should show 1st - 30th November 2015 dates

In 2020, it should show 1st-30th November 2020 dates.

**Special-K** · 09-25-2015, 09:46 AM

You need to be more specific.
What's your input that will generate a November date?

Any November date within the current year

LinkBack

Thread Tools

Rate This Thread

Display

Any November date within the current year

Re: Any November date within the current year

Re: Any November date within the current year

Re: Any November date within the current year

Thread Information

Users Browsing this Thread

Similar Threads

Entering only the date displays current date with month & year

[SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year

[SOLVED] How to get monthname and year of the current date?

Keep month and date but change year to current year and reoccur when new year rolls over.

[SOLVED] Need Calculation - If A1=Annual, Anniv. Date for Current Year, else Biennial Date

[SOLVED] Keeping a date as current year, even though formula determines previous year

VBA. If date = first day of the month then return months value (e.g. November)

Bookmarks

Bookmarks

Posting Permissions