how to find day count

Report Inappropriate Content · ‎2013-01-11

martin59 · ‎2013-01-11

What do you mean ?

NumberOfDaysBetween2Dates=Date1-Date2

Hope that helps you

Martin Favier

MayilVahanan · ‎2013-01-11

Hi

Use interval() function

For Ex:

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

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Gabriel · ‎2013-01-17

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

Related Topics