how to find day count

[#1]

how to find day count

[martin59]

What do you mean ?

NumberOfDaysBetween2Dates=Date1-Date2

Hope that helps you

Martin Favier

[MayilVahanan]

Hi

Use interval() function

For Ex:

Interval(Today()-(Today()-2),'D') gives 2

hope it helps

[Gabriel]

Hi,

If I understand you well, you want to know the function to count the day of the year?

If that is the case,use this function

=DayNumberOfYear(Today(),1)

1 is the number of the month

Let me know if it works.

Regards,

Gabriel