Help! Date formulas is a sentence!

[dmontez]

Need to know the formula for a cell to read
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
“August 20, 2008 through February 20, 2009”
<o> </o>
Need dates to auto changed based on todays date. The last date being todays date and the first being the date 6 months prior to today.
<o> </o>
Thanks!

 

[Jonmo1]

Try

=TEXT(TODAY()-6,"mmmm dd, yyyy") & " through " & TEXT(TODAY(),"mmmm dd, yyyy")

 

[Numberz]

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),"mmmm dd,yyyy") & " through " &TEXT(TODAY(),"mmmm dd, yyyy")

 

[Jonmo1]

Doh! 6 MONTHS not 6 days....LOL

 

[Jonmo1]

Try

=TEXT(EDATE(TODAY(),-6),"mmmm dd, yyyy") & " through " & TEXT(TODAY(),"mmmm dd, yyyy")

EDATE requires the analysis toolpack addin from Tools - Addins

Also, if you're planning on using this type of formula alot, you'll be well served puttin g =TODAY() in a cell by itself, then refer to that cell in the formula.

Say A1 =TODAY()
=TEXT(EDATE(A1,-6),"mmmm dd, yyyy") & " through " & TEXT(A1,"mmmm dd, yyyy")

 

[dmontez]

Worked perfectly! Thank you so much for your time!

Daniel