# Number of days to date

#### duck60

##### New Member
Hello. I am trying to write a formula that takes into consideration a start point. Our fiscal year began Jul 1, 2007. Taking that into consideration, I am trying to write a fomula that takes todays date -today() and gives me a number which today is 33, (the number of days between Jul 1 and today.)
Could you help me out. I have a block with todays date in it that updates as soon excel is started. I just need help with the formula.

Thanks for the help and assistance

Doug

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
You should just be able to subtract the two, the result will be the number of days.

Code:
``=TODAY()-A1+1``
Edit:
Format as number.

Assuming today's date in A1, perhaps:

=A1-DATE(YEAR(A1)-(MONTH(A1)<7),7,1)+1

Format as General.

Hi duck60:

Let me see if I undestand you correctly ...

Excel Workbook
ABCD
1TodayDateFiscalYearBeginDate
28/2/20077/1/200733
3
Sheet9

</body></html>

I don't know whether the answer you are looking for is 32 or 33 ... make adjustment to the formula accordingly.

Replies
2
Views
207
Replies
3
Views
598
Replies
4
Views
527
Replies
4
Views
167
Replies
1
Views
120

1,221,410
Messages
6,159,723
Members
451,587
Latest member
srice33

### 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.

### Which adblocker are you using?

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

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