% booked within Quarter -- Excel formula Help

[McNeil87]

Hello!

I am trying to write out an excel formula for % booked within quarter. This is what i use for % booked by month:
=DAY(TODAY())/DAY(EOMONTH(TODAY(),0))

Any suggestions would be great -- thank you!

 

[etaf]

you are taking todays day - ie today is the 11th
so Day( today() )
is 11
and then dividing by the number of days in a month - so July
31

11/31 = 35.5%

What % are you looking for , thats not booked as its just today() - so nothing may actually have been booked today -

can you give examples please

what do you define as a quarter ?

 

[McNeil87]

you are taking todays day - ie today is the 11th
so Day( today() )
is 11
and then dividing by the number of days in a month - so July
31

11/31 = 35.5%

What % are you looking for , thats not booked as its just today() - so nothing may actually have been booked today -

can you give examples please

what do you define as a quarter ?

Thanks for your reply. Essentially, taking current date (so, July 11th). I want to see how much is booked for Q3 (July - Sep)