Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to find day count
What do you mean ?
NumberOfDaysBetween2Dates=Date1-Date2
Hope that helps you
Martin Favier
Hi
Use interval() function
For Ex:
Interval(Today()-(Today()-2),'D') gives 2
hope it helps
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