With
A1: a date
This regular formula returns the value you asked for
Is that something you can work with?![]()
B1: =FLOOR(MONTH(A1)-1+DAY(A1)/DAY(EOMONTH(A1,0)),0.01)
With
A1: a date
This regular formula returns the value you asked for
Is that something you can work with?![]()
B1: =FLOOR(MONTH(A1)-1+DAY(A1)/DAY(EOMONTH(A1,0)),0.01)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks