Counting Days with VBA

[bloodmilksky]

Hi Guys,

I was just wondering if anyone has the VBA syntax for counting days. in C21 I have 01/01/2016 in D21 I have 11/01/2016.

If possible I would like the total amount of days shown in B21

any help would be greatly appreciated many thanks and all the best

bloodmilksky

 

[JeanKim]

=d21-c21
is this what you asked?

 

[bloodmilksky]

Hi,

Not quite I would like that when I enter the dates From(C21) To(D21) that it shows me how many days there are. so for the example above the result should be 11 days.

Many thanks

jamie

 

[JeanKim]

First, is it Jan 1 to Jan 11?
Second, Below statement is confusing.

If possible I would like the total amount of days shown in B21

Total number of day then would be =d21-c21+1 which equal to 11 if you are counting days for time period Jan 1 to Jan 11

need more clarification

 

[bloodmilksky]

Hi Sorry To start over but I have confused everything.

so in A1 I have 01.01.2016 and in A2 I have 15.01.16 and I need to know the amount of days between those dates shown in A3?