Is there a function or combination of functions that will return the day of the month? For instance, on the 24th of every month if I wanted it to return "36", =IF(A2= (...the 24th of the month...),36,"").
Is there a function or combination of functions that will return the day of the month? For instance, on the 24th of every month if I wanted it to return "36", =IF(A2= (...the 24th of the month...),36,"").
=if(day(A1)=24, 36, "")
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks