# Does Excel contain a Year to Date Function?

#### hoff123

##### Board Regular
Good Morning,

I have been trying to create a report which takes into account the number of work actions undertaken in the year to date over the current number of days in the year.

For example i have worked 100 different actions on 28/11/2005, now i want to be able to calculate the average rate of actions per day based on what day it is in 2005 i.e. 100(actions)/300(the number of days that have elapsed in 2005, with 365 being the maximum).

Is this possible?

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You can get the number of days so far this year with

=TODAY()-DATE(YEAR(TODAY()),1,0)

does that help you at all?

To get the number of days elapsed this year. (at least within 1 day)

=Mod(Today(),365.25)

Looks like you want:

#Actions/Mod(Today(),365.25)

Hi,

Thanks for the info really helped. Further to the above i tried modifying the function:

=TODAY()-DATE(YEAR(TODAY()),1,0)

To

=TODAY()-DATE(MONTH(TODAY()),1,0)

However this does not give me what i really need

Thanks.

Sorry , hit submit 2 early. What i basically need is the above function by year, and another by month or more specifically the function to find the number of days in current month.

Thanks

Try

=DAY(TODAY())

Wouldn't DATEDIF work in this situation, or am I misreading the post....as usual...

Replies
10
Views
358
Replies
6
Views
247
Replies
8
Views
551
Replies
15
Views
1K
Replies
1
Views
209

Threads
1,220,980
Messages
6,157,189
Members
451,404
Latest member
Probe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back